Hello, On Mon, 23 Aug 2021 at 12:30, sankarshan via plug-mail <plug-mail@plug.org.in> wrote: > > > > On Mon, 23 Aug 2021, 11:01 Amey Abhyankar via plug-mail, > <plug-mail@plug.org.in> wrote: >> >> Hello, >> >> I am trying to restore MySQL DB dump from 1 MySQL instance to another. >> >> I tried various guides but if I try to backup & restore ALL db's in 1 >> go, it is not working. >> But If I backup & restore a single db, it works. > > > You haven't provided additional information about the commands you are using > to backup and restore. And what is the command which works for a single db?
I don't know which command worked as I tried multiple combinations. Do you know the exact set of commands which can take backup of ALL db's using dbdump command and restore ALL db's using mysql command? I guess in my case the ALL db backup worked using following command = mysqldump -u root -p --all-databases > all_databases.sql Following is 1 of the command I tried to restore ALL db's = mysql --one-database database_name < all_databases.sql I also tried to backup DB structure + data & restore using following guide = https://www.sqlshack.com/how-to-backup-and-restore-mysql-databases-using-the-mysqldump-command/ Didn't help for the restore part. Regards, Amey. > >> >> The size of total DB's is not much i.e. less than 300MB in total. >> >> Just wonder if anybody knows the reason for this issue. >> Logs are not explaining anything about the issue. >> >> Thanks & Regards, >> Amey. >> _______________________________________________ >> plug-mail mailing list >> plug-mail@plug.org.in >> http://list.plug.org.in/listinfo/plug-mail > > _______________________________________________ > plug-mail mailing list > plug-mail@plug.org.in > http://list.plug.org.in/listinfo/plug-mail _______________________________________________ plug-mail mailing list plug-mail@plug.org.in http://list.plug.org.in/listinfo/plug-mail
