[PLUG] MySQL 5.7 is unable to restore the DB Dump

[Amey Abhyankar]

Hello,

On Mon, 23 Aug 2021 at 12:30, sankarshan via plug-mail
<plug-mail at plug.org.in> wrote:
>
>
>
> On Mon, 23 Aug 2021, 11:01 Amey Abhyankar via plug-mail, <plug-mail at 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 at plug.org.in
>> http://list.plug.org.in/listinfo/plug-mail
>
> _______________________________________________
> plug-mail mailing list
> plug-mail at plug.org.in
> http://list.plug.org.in/listinfo/plug-mail