I am using mysqldump in my cmd to export an entire database, the problem is that when I run this code, it only exports the first table and not the others. I have been researching about this problem and didn't find any kind of solution. The code is the following:
mysqldump -u root bancos > C:\xampp\htdocs\backupdb\backup\bancos.sql
Where my tables are these:
And when exporting it, the result would be the following:
As you will see, it only exports the first table and not the others, I don't know if this would happen because of the little memory I have on my computer or the version of MySQL I have, my operating system is Windows 10, I would greatly appreciate your help.
Solved, the solution was to skip the following error:
And to skip this error, you had to put the following:
And finally, my final code would be like this:
This way
mysqldump
he will bypass this error and continue to export all tables, thank you very much for your help.