Page 1 of 2
restore database
Posted: Tue Nov 22, 2022 1:27 am
by 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 ?
Re: restore database
Posted: Tue Nov 22, 2022 1:43 am
by kev1n
Hi,
The easiest way to do so is to import the backup file via
phpMyAdmin.
Re: restore database
Posted: Thu Dec 01, 2022 6:06 pm
by kev1n
Hi,
Did that help?
Re: restore database
Posted: Thu Dec 01, 2022 6:42 pm
by 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
Re: restore database
Posted: Thu Dec 01, 2022 6:55 pm
by kev1n
Any errors?
Re: restore database
Posted: Thu Dec 01, 2022 7:48 pm
by 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

Re: restore database
Posted: Tue May 20, 2025 2:12 am
by 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?
Re: restore database
Posted: Tue May 20, 2025 2:38 am
by 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?
Re: restore database
Posted: Tue May 20, 2025 6:04 pm
by 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
Re: restore database
Posted: Wed May 28, 2025 3:25 am
by 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