Question

18

rated 0 times [ 18] [ 0] / answers: 1 / hits: 39813 / 3 Years ago, fri, may 21, 2021, 8:27:18

I have exported all my databases to a file using phpMyAdmin.

Unfortunately I don't have a working phpMyAdmin in my destination system.

How should I restore all of them at once using one line command?

Only authorized users can answer the question. Please sign in first, or register a free account.

Total Points: 3

Total Questions: 126

Total Answers: 109

Location: India

Member since Sun, Feb 6, 2022

2 Years ago

luringdge questions

Sun, Oct 17, 21, 08:22, 3 Years ago

Fri, Dec 30, 22, 23:57, 1 Year ago

Sun, Oct 10, 21, 07:21, 3 Years ago

Sun, Apr 16, 23, 13:31, 1 Year ago

Tue, May 4, 21, 08:02, 3 Years ago

answered 3 Years ago impisaso · Accepted Answer

Why don't you concat all the files into one single file and import/restore using

mysql -u username -p < dump.sql

Create one file using

mysqldump -u username -p --all-databases > dump.sql