Restore SQL backup into MySql through the console SSH

ezapiola 2021-02-08 22:17:09 UTC #1

I'm using Google Cloud Platform with Bitnamoi Lampstack 575e,
I can access PhpMyadmin and everything is ok.
I need to restore a backup from my old website which is 700K, I can't import it with the PHPMyAdmin because it is too big.
I restore that large sql backup into the localhost using the XAMPP console without problem.
I use the command:

mysql -u root -p
use my-database
source backup-db.sql;
And then:
ERROR: 
Failed to open file 'backup-db.sql', error: 2

I tried with c:\backup-db.sql, "c:\backup-db.sql", 'c:\backup-db.sql', "c:/backup-db.sql", and all combinations. Its impossible to find the way. Any clue ?

fdepaz 2021-02-09 11:27:30 UTC #2

Hello @ezapiola,

To restore a MySQL backup you can follow our guide Create And Restore MySQL/MariaDB Backups. If you already have the .sql file if you previous database you can restore it with:

mysql -u root -p -D bitnami_app < backup.sql

ezapiola 2021-02-11 16:17:04 UTC #3

The solution is uploading the backup.sql file into the /htdocs folder and changing to that folder before starting the MySql:

cd /opt/bitnami/apache/htdocs

Thank you anyway.

fdepaz 2021-02-15 09:07:36 UTC #4

Hello @ezapiola,

I'm glad you could solve it and thanks for sharing the solution with the community!

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!