[Help] WHMCS Large Database Dump

Mridul

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.

jar

Stop using web based scripts and use the proper tools.

Export: mysqldump dbname > dbname.sql
Import: mysql dbname < dbname.sql

Done

Mridul

What will be the exact command in CentOS ?

@Jar said:
Stop using web based scripts and use the proper tools.

Export: mysqldump dbname > dbname.sql
Import: mysql dbname < dbname.sql

Done

jar

Mridul said: What will be the exact command in CentOS ?

These are correct in all distributions:

Jar said:
Export: mysqldump dbname > dbname.sql
Import: mysql dbname < dbname.sql

Mridul

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

@Jar said:

Andreix

@Mridul said:
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.

Sady

@Mridul said:
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

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?

shyaminayesh

https://github.com/shyaminayesh/SQLBackup/blob/master/backup.sh

hope this will give you help or you can get idea about the backup command