update table structures from another server
-
Hi, I have two MySQL servers.. one is sourceMySQL and targetMySQL. I want to update all the tables but WITHOUT the data on the targetMySQL using sourceMySQL without having to do it one by one so it will only update the table structure... Is there anyway to say: UPDATE all table structure IN targetMySQL FROM
-
Hi, I have two MySQL servers.. one is sourceMySQL and targetMySQL. I want to update all the tables but WITHOUT the data on the targetMySQL using sourceMySQL without having to do it one by one so it will only update the table structure... Is there anyway to say: UPDATE all table structure IN targetMySQL FROM
Your best bet would be to get a copy of MySql workbench MySQL Workbench Downloads[^], then under Server Administration -> Data Dump -> Advanced Export Options, you can select the No Data option, and this will give you a script which will contain all the Create Table statements for the selected database, without data. You can also select to include all stored procedures in the same script. Hope this helps
When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman