I have a MySQL DB on a server and am required to migrate them to another. These 2 DB servers are not from the same web hosting company and I have limited access rights to them. I am given a script and if run, it will generate create tables and insert default records onto the new database server. I will then do a delete all records from all tables. Now comes the interesting part - Import all records from original database server to new database server.
My instinct tell me to come out with a script and convert all existing records from tables into INSERT statements. Then use run these statements on the new database server. I have got more 30 over tables with no foreign keys (this makes things simpler). Anyone have got a generic script that will generate INSERT statements for all tables?
http://www.experts-exchange.com/Database/MySQL/Q_23116695.html
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Google url shortener service, goo.gl , is now much improved with newly included features like easier copy and paste, and ability to delete e...
-
I would like to apologize that sigining of my guestbook is not possible at the moment due to an unexpected bug. There is already 74 entries ...
-
Get accurate and real-time bus arrival information for public bus operators in Singapore, including SBS Transit, SMRT Buses, Go-Ahead Singap...
-
Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed m...
-
*********** Try to sleep now, close your eyes Soon the birds would stop singing Twinkling stars, are shining bright They'll be watch...
That's what I found.
ReplyDelete1. phpMyAdmin will help
http://www.phpmyadmin.net/home_page/index.php
2. mysqldump will also help
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
hongjun