Portal Home > Knowledgebase > Articles Database > mysql move need help
mysql move need help
Posted by bazb, 02-04-2006, 05:32 PM |
Hi, I have downloaded an entire mysql databse from my old server tho i wish to move it to my new server and upload it to over write all database on my server, The file is over 100mb so i was wondering what would be teh ebst and quickest way to upload to my new server and update the databases on it as a lot of teh are corupt due to the transfer move
anywya a can acieve this?
|
Posted by teksupportrena, 08-02-2009, 02:02 PM |
The databases should have the records in the mysql database table.
If the DB server (mysql) installed in your new server is of the same version that in the old server, after copying the databases, you only need to restart the mysql process in the new server.
Otherwise, you have to take the backup (in .sql format) of all databases using mysqldump , then restore it in the new server.
|
Posted by Thomas Manning, 08-02-2009, 02:56 PM |
If the Mysql version of the source and destination server are the same, then you can simply copy the entire /var/lib/mysql from the source server and paste it in the destination server.
Otherwise the best method is to take the database dump of all the databases and restore them in the destination server.
|
Posted by bazb, 08-02-2009, 03:07 PM |
do ur selfs a favour guys dont use the search function to help peoples prob if there over 3 years old. i made this post in april 2006 if u care to read the date
|
Posted by Thomas Manning, 08-02-2009, 03:34 PM |
Oops... I Missed that. Really Sorry
|
Add to Favourites Print this Article
Also Read