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?
- ► 2012 (318)
- ► 2011 (1050)
- ► 2010 (1303)
- ► 2009 (1010)
- Internet outages hit India, Middle East
- Google is Always Experimenting
- Cathay to Increase Cost of Ticket
- Sync Your PC Clock to Internet Servers Using Comma...
- Help Needed - Convert all Data to Insert Statement...
- Budget Day on 15 February 2008
- Donation to the Charity
- Was Reading a Old Post - NUS Summary
- U.S. Spy Satellite, Power Gone, May Hit Earth
- Mr Suharto Died (1921 - 2008)
- PDFTextOnline : Hassle-free PDF to Text Converter
- What is svchost.exe?
- My Mobile Blog
- How to Make Your Blog Mobile Friendly?
- I Got a Blog at SgDotNet
- Disable PC Beep Sound
- Microsoft Internet Explorer 8 Pass Acid2 Test
- Stock Tumble Drives 43 Benchmarks Into Bear Market...
- Asian Markets Tumble Hard Once Again
- Asian Markets Tumbled Badly
- Sun to Acquire and Merge MySQL
- LTA $2m Gallery Is Opened
- Standard Chartered's e$aver Accounts Interest Rate...
- Overhaul of Bus System for Singapore
- Microsoft Support Sucks Big Time This Time
- Polar Bear is Threatened to be Endangered
- OpenID - Eliminates Need for Multiple Usernames Ac...
- Straits Times Index (STI) 14-18 Jan 2008
- Vulnerability in Microsoft Excel Could Allow Remot...
- Gmail Not Working On Internet Explorer 7.0 - Solut...
- Kill A Stuck Pixel or Dead Pixel
- Introducing MacBook Air - The World's Thinnest Not...
- My Windows Live Account Intruded and Hijacked?
- Make Pointui Work on Windows Mobile 6
- Repair and Fix Your Registry
- Yahoo Finance Not Showing Live STI As Well
- Cloned Animals to Produce Milk, Meat for US
- Ultimate List of Free Essential Software
- New Revamped STI Causing Unhappiness Among Investo...
- Stock Market Weakest In 4 Months
- Singapore Hosptial Means Testing
- Convert Image File Format From One to the Other Wi...
- Orcas is Out!
- NUS President Head Hunted
- CNG Cheaper Alternative for Expensive Petrol
- Remarks by National Library Board Security Officer...
- Stock Market Moving in One Direction
- Busy at Least for 1 More Month
- My Enquiry to SBS Transit On a Bus Incident
- Free PDF to Word Doc Converter
- Changi Airport Terminal 3 Opens Today
- Long, Tiring, Busy Yet Eventful Day
- Yahoo to Launch Mobile Services
- Quotes From Google's Founders
- Wireless@SG Coverage Search
- JobsDB Career Expo 2008
- Wikia Search Launched
- POSB Coin Deposit Machines
- DBS Coin Deposit Machines
- Pointui Skins Windows Mobile
- Got my Experts-Exchange 2 Million Solutions T-Shir...
- Carrefour Logo and Its Meaning
- My Top 10 Best Products (Jan 08)
- ▼ January (63)
- ► 2007 (479)
- ► 2006 (338)
- ► 2005 (232)
- ► 2004 (389)