Jump to content
The Uniform Server Community

Migrate SQL database from WAMP to Uniserver


dgd5v
 Share

Recommended Posts

We are currently trying to switch from using WAMP, to UniServer. The main issue is trying to find where in the directory structure to insert our exported data from WAMP. Is it simply copying and pasting the sql file into a directory or is it more complicated? If it is as easy as pasting into a directory, which one would accomplish this?

 

Thanks!

Link to comment
Share on other sites

Normally I don't recommend the simple cut and paste, but you can give it a try. :)

It's typically the app data that messes things up.

 

All MySQL data is stored in \usr\local\mysql\data. Caveat: MyISAM tables will transfer properly, but InnoDB tables are all combined in the ibdata and ib_logfile. They don't transfer as well. Instead you should do an export/import of the SQL using phpMyAdmin. You'll also get a chance to scan for path strings in the data, which would make your app fail (even though the DB worked fine).

Even if you're changing between MySQL versions, the copy/paste will still work, since I don't think that the structure has been modified much. Example: the application plugins made for 5.6-Nano work properly with 7-Orion versions, and they're all MyISAM-based.

 

Regards,

BobS

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...