Entry

Database: MySql: Operation: Replace: How to replace a MySql database with other MySql database?

Nov 22nd, 2008 00:46
haytham ali, Knud van Eeden, dman,

----------------------------------------------------------------------
--- Knud van Eeden --- 08 May 2021 - 09:35 pm ------------------------
Database: MySql: Operation: Replace: How to replace a MySql database 
with other MySql database?
---
This is might be e.g. necessary when you develop your
database on your local machine, and then you have to
upload this new or latest MySql database to your web server.
---
Steps: Overview:
 1. -Backup the source database using PHPMyAdmin
     1. -Use the 'Export' option
 2. -Backup the destination database using PHPMyAdmin
     1. -Use the 'Export' option
 3. -Load the source database in MicroOlap
     1. -Via 'Reverse Engineering'
 4. -Generate the database SQL code in MicroOlap
     1. -Via 'Generate database'
 5. -Execute the MicroOlap SQL code on the destination database,
     that will recreate this databases new
     1. -Paste that SQL code in PHPMyAdmin
 6. -Insert the source database data in the destination database by
     executing the backup source database SQL
     1. Start that database in PHPMyAdmin
     2. -Select tab 'Export'
     3. -Paste the backup PHPMyAdmin export SQL code
     4. -Run that SQL code
 7. -Then possibly upload and run your webpages for this new
     destination database
---
---
Internet: see also:
---
Database: Design:MicroOLAP Database Designer for MySQL: How to 
generate SQL code to create database?
http://www.faqts.com/knowledge_base/view.phtml/aid/36073/fid/1803
http://6rb.com
http://fr7.com
http://dir.msryat.org
http://6ef.com
http://forums.msryat.org
http://www.arabcar.com
----------------------------------------------------------------------