var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Inserting Data From One Database to Another
Thank you kindly for taking the time to read this.
I have two databases:
-Database A (This has all my customer data, order data, etc). With 250 odd tables.
-Database B (This has all the tables, but is blank with no data).
The databases are almost exact, a few new tables in Database B. They are both on localhost.
Now, how is the best way to move all the data from Database A, into the exact same tables that are blank on Database B?
I mainly script HTML/PHP, and as such have little knowledge of MySql.
I am hoping someone can assist as it would be greatly appreciated.
Originally Posted by
mysqldump, then feed the .sql file into the target database through either the command line or some front end app like heidisql or the mysql browser
As Rudy says use mysqldump to generate the SQL statements needed to backup your primary database. You should make sure that your destination database is newly created with no tables. If you have tables created with triggers enabled you may end up with data inconsistencies i.e. duplicate records.