Jump to content
Larry Ullman's Book Forums
Sign in to follow this  
Peter77

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?

Share this post


Link to post
Share on other sites

That *might* work, but what you really should do is use an export and import utility. MySQL comes with command-line versions, but I normally recommend using phpMyAdmin instead.

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×