Dev License: This installation of WHMCS is running under a Development License and is not authorized to be used for production use. Please report any cases of abuse to abuse@whmcs.com

Import Export MySQL database using PhpMyAdmin Print

  • 1
Do the following steps for import/export mysql database:

Open phpMyAdmin.by going to mysql.yourdomain.com (replace yourdomain.com with your own domain name)
  1. Click Export in the Menu to get to where you can backup you MySql database.
  2. Make sure that you have selected to export your entire database, and not just one table. There should be as many tables in the export list as showing under the database name.
  3. Select”SQL”-> for output format, Check “Structure” and “Add AUTO_INCREMENT” value. Check “Enclose table and field name with backquotes”. Check “DATA”, check use “hexadecimal for binary field”. Export type set to “INSERT”.
  4. Check “Save as file”, do not change the file name, use compression if you want. Then click “GO” to download the backup file.

Restoring a backup of a MySql database

  1. To restore a database, you click the SQL tab.
  2. On the “SQL”-page , unclick the show query here again.
  3. Browse to your backup of the database.
  4. Click Go.

Was this answer helpful?

Related Articles

Connection Strings (MSSQL 2005, MSSQL 2008, MySQL5, MS Access Database) MSSQL2005Set conn = Server.CreateObject("ADODB.Connection")conn.Open "Provider=SQLOLEDB; Data... How do I use an Access database on my site? Microsoft Access is part of the Microsoft Office suite of applications and is a database that is... The server principal "userXYZ" is not able to access the database "DB_DNP" under the current security context. (Microsoft SQL Server, Error: 916) To fix this SQL Server Management Studio 2008 Bug, please follow the directions below: Open... What is MySQL? MySQL is an open source database server, much like Microsoft SQL Server or Oracle. You can store... What connection parameters do I use to connect to my database Connection information : You can connect to your database either via a dns name ie...
« Back

Powered by WHMCompleteSolution