MySQL Database Compatibility

Problem:

How do I make my MySQL database compatible with the version you provide?

Solution:

If your version of MySQL is a later release than ours, you can export the database to make it compatible with ours. To do this you would run the below command from the command prompt on your server.

mysqldump --compatible=mysql40 -udb_USERNAME -pdb_PASSWORD db_name > FILENAME

Note: Replace db_name, db_USERNAME, db_PASSWORD, & FILENAME with the name of the database, the user, the password, and the file name, respectively.

  • 33 Utenti hanno trovato utile questa risposta
Hai trovato utile questa risposta?

Articoli Correlati

MySQL Database Creation

Problem: How do I create an empty MySQL Database? Solution: Databases offer a method for...

Remote Database Connection Setup

How do I remotely connect using a database management software? Databases in cPanel can be...

MySQL Import and Export (.sql file) via SSH

Problem: How to import and export a MySQL Database from the command line. Solution: MySQL...

MySQL Import and Export (.sql file) via PhpMyAdmin

Problem: I need to Export or Import a MySQL database Solution: Note: PhpMyAdmin can only...

Connecting to your MySQL DB from Dream Weaver

Problem: How can I connect to our MySQL database from Dream Weaver? Solution: Log into your...