Copy a MySql Database
Moderator: General Moderators
Copy a MySql Database
I have a MySQL Database on my domain hansteam.net that I need to move to my client's domain at halfpricetools.ca for a client. hansteam.net uses plesk and halfpricetools.ca uses cpanel. I've basically started coding a method of taking all of the information out of the first database but I'm still having to code the creation of the tables in the second database. If anybody here has a solution that involves a copy and paste more or less, i'd be very interested to hear of it!
dump the database structure and data using phpMyAdmin or the like then paste it to your new target using the same.
I've had to do this many times in the past and on a few occasions with extremely large databases. In those cases I had to break it into chunks and paste and execute small(er) amounts of data at a time.
with older versions of MySQL, you could simply grab three files and copy them from one machine to another, but I have not tried that with anything newer than ~Dec 2002.
I've had to do this many times in the past and on a few occasions with extremely large databases. In those cases I had to break it into chunks and paste and execute small(er) amounts of data at a time.
with older versions of MySQL, you could simply grab three files and copy them from one machine to another, but I have not tried that with anything newer than ~Dec 2002.