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
Computer, Technology, Databases, Google, Internet, Mobile, Linux, Microsoft, Open Source, Security, Social Media, Web Development, Business, Finance
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Ever looked up from your phone, realized your bus was pulling away, and had to sprint like you were running the 2.4km NAPFA test? We are put...
-
新加坡人口400万,亚洲人口4亿,全世界人口6亿。 但是,我一人可能就很有可能是世界最傻的了。我真是个不折不扣的大木头。真是受不了自己。
-
I was at Bugis Junction today and saw 蘇打綠 (Soda Green) performing. They look so much different especially the lead singer. I find their song...
-
Taking a break? Find music videos from the artists you love with Google's improved music video search results . People often come to G...
-
Watch Sim Ann's rally speech, described as a speech "dripping with sarcasm" against her opponent in the election contest, Dr C...
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