restore database

[jacdem]

Hello, I see where to make a backup and it works great. But I can't find the menu to do a restore. How can I make a restore ?

[kev1n]

Hi,

The easiest way to do so is to import the backup file via phpMyAdmin.

[kev1n]

Hi,

Did that help?

[jacdem]

Hello, phpMyAdmin gives errors with tables that start with XXXX
I'm looking for a script in php to make restores like MySQL Dumper which worked great with backup and restore, but it doesn't work anymore with php8.1

[kev1n]

Any errors?

[jacdem]

Sorry I was wrong, these are the ZZZZZ tables
The ones created by your script
After restore I have to fix my forum because there are errors. My text editor does not work anymore
MySQL Dumper was very slow but did not give any error in backup and restore

[Lala]

Hi
I have backed up my database which is hosted on a web page. Now that it has gone live, I want to continue its development on localhost. I backed up the live database and downloaded the backup file, but when I try to import to my wampp server using phpmyadmin it I get a message saying that there is a fatal javascript error. What am I doing wrong?

[kev1n]

Hi,

To help you more effectively, could you please provide the exact error message you're seeing? You mentioned a "fatal JavaScript error" — is this coming from phpMyAdmin itself, or do you see it in the browser console (press F12 → Console tab)?

How did you back up the database on your live site? Did you use phpMyAdmin or some other method?

[Janusz]

Hi,
I do not know if it's relevat for WAMP (if mariadb-dump & mariadb are available from command window).
On Linux I use only following commands from terminal to save and restore:
mariadb-dump --events --routines -u globeadmin -ppassword myDBase > myDBasecopy.sql
mariadb -u globeadmin -ppassword myDBase < myDBasecopy.sql

[Lala]

I backed up the database two different ways; I used the backup feature in Nubuilder and I also exported the database using phpMyAdmin. I am no longer getting the javascript error, but I am getting an error that says that the file is too big when I try to import it to phpMyadmin on my local server whichever export/backup file I try to use