Jump to content
Larry Ullman's Book Forums

How Do I Copy A Mysql File To The Server

Recommended Posts

Please bear with me - I'm a MySQL dummy - aka beginner. I have a couple tables on my local machine. I have MySQL 5.5 also installed as a server on the remote server. Do I just copy the files - is that it? On my local machine (XP) they are located at:


C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.5\data


On the server I have:


C:\ProgramData\MySQL\MySQL Server 5.5\data


Do I just copy the project folder or do I have to perform some sort of install or instantiation?

Link to comment
Share on other sites

You can actually just export the file. If you go to the PHPMyAdmin and view the database you want to copy, there should be an export tab, click it and save the file to your desktop, then you can just copy all the SQL commands into the other hosts PHPMyAdmin under the SQL tab and dump all the data in like that. That's what I do.

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.
Note: Your post will require moderator approval before it will be visible.

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.


  • Create New...