Apps backup - Big Database

[Ryan Gil]

Hello,

Just a question, whats is the best process to restore a database when the database has a big size ?

[Patrick]

The best is to make with your console, the problem is your OS has a time limit  and a size limit to upload your database fixed in php.ini

[Patrick]

You can try that :

 

Backing up a single database
mysqldump -u username -p database_name > data-dump.sql



Restoring or loading the database
mysql -u username -p new_database < data-dump.sql

[Ryan Gil]

@Patrick

Ok thank you for the code.

Edited January 15, 2020 by Ryan Gil