All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
[Help] WHMCS Large Database Dump
Hi,
I have been using "bigdump" ( www.ozerov.de/bigdump/) to import my old WHMCS ( v 5.3.12 ) database to a new vps, and upgraded to WHMCS 5.3.14.
I have to use BigDump as phpmyadmin wont import my 2.5 MB ( compressed ) database.
The database gets imported and whmcs ( v 5.3.14 ) upgrades and runs smoothly.
The problem is, the comparison of old and new whmcs install shows a difference in database.
The No. of tables is same but the size of the old Database is 24 MB ( whmcs v 5.3.12 ) , while the new install ( whmcs v5.3.14 ) , shows it to be only 17 MB.
There is also a difference in the no. of rows, in old install its close to 72,000 , in new its 71xxx.
Surprisingly all the whmcs functions ( as of now ) are fine on the new install. How can i diagnose the issues ?
Plz advise.
Comments
Stop using web based scripts and use the proper tools.
Export: mysqldump dbname > dbname.sql
Import: mysql dbname < dbname.sql
Done
What will be the exact command in CentOS ?
These are correct in all distributions:
I Used the Command :
mysql -p -u db_user db_core < db_core.sql
The system asks for a password , then no error and Database is not imported.
Any ideas ?
Note :
db_user = database username
db_core = new , empty database already created in Vesta CP.
db_core.sql = the uploaded file in the folder , Permissions = 755
Hello there,
Your command is correct. If the database is not imported, you can try to debug it a little bit
mysql --debug-info -u user -p database < db.sql
And see the result.
It looks good, have you tried
mysql -p -u db_useruser
show tables from db_core;
To make sure that it's imported or not?
https://github.com/shyaminayesh/SQLBackup/blob/master/backup.sh
hope this will give you help or you can get idea about the backup command