Extract every single DB from a large (full) phpmyadmin DB backup

[GeezNotThatGuy]

 

[fistor]

Why didn't you just use the f operator?
Or did it stop anyway?

 

[MafiaBoss]

oh the code, the code, make me dizzy.

 

[GeezNotThatGuy]

For my defense: My focus is on creating content, not handling server issues. I have just very basic knowledge and my serveradmin was asleep when the problems arose.
So could you please elaborate? What is the f operator? And by the way, i tried to change stuff in the config tab in phpmyadmin, but for whatever reason i allways just got a blanc site.
I know that there would have been an option to ignore errors.

 

[GeezNotThatGuy]

 

[Izzma]

If you are using cPanel why don't you use "Backup Wizard"? You can easily download your .SQL data and public_html directories with the click of a button.

I have literally millions of entries I either export or restore on a monthly basis and never have a problem. For the people who don't use cPanel, try MySQL Dumper. It works just as well.

 

[GeezNotThatGuy]

 

[fistor]

For my defense: My focus is on creating content, not handling server issues. I have just very basic knowledge and my serveradmin was asleep when the problems arose.
So could you please elaborate? What is the f operator? And by the way, i tried to change stuff in the config tab in phpmyadmin, but for whatever reason i allways just got a blanc site.
I know that there would have been an option to ignore errors.

Gotcha!
Just to make it clear, you don't have to defend yourself, as I was just asking. The f (force) would have been the first thing I would have tried.

Basically PhpMyAdmin is just an interface for your Database. You could navigate to your MySQL folder directly via shell (such as putty) or directly via remote (cmd etc).
Then you tell MySQL to import your Database Dump, without the "help" of PHPMyAdmin.

You do that with a command such as mysql -uuser -ppassword < dumpfilenamehere.sql (IIRC! Been a long time since I messed with MySQL)
If that should throw errors (unlikely), you can force MySQL to ignore the errors by adding -f or --force to the command above.

That should have imported all your databases anyway.

Again, long time since I played with MySQL. If anyone experienced finds this to be wrong, feel free to correct me. But imo, this should work.

 

[tompots]

When it come to technology, short cuts will screw you every time. Hope you get that sorted.

 

[GeezNotThatGuy]