I’m sorry but these are English language forums, so please use English or provide an English translation. Alternatively, use a WP support forum in your language.
Hi,
I have a dump from BackWPup Version 2.1.17 and XAMP 1.8.2. with PHP 5.4.19.
I wish to restore a sql-file with 46 MB to XAMP on Windows 7. php MyAdmin failed because the sql-file is to big.
How I can import the backup sql-file from WP plugin backWPup to the mySQL on XAMP.
Thank you for help.
mustermann
Hello,
give http://www.mysqldumper.de/ a try. also you can use the mysql command from commandline. For this are many Manuals on the net.
Thank you for help Daniel, but I used mysql commands from commandline and it did not work:
mysql.exe -u root -p
“\u d00123”
Start import with the sql-file direct in C:\
“\. C:\ d00123.sql“
Then I got this message:
ERROR:
Failed to open file `d00123.sql, error: 2
Please don’t use the C:\ folder fo that. Make a subfolder in C:\. C:\ has Special permissions.
Daniel,
if I use the shell in XAMP with this code
\. C:\temp\d00123.sql
Then I got this message:
ERROR:
Failed to open file `d00123.sql, error: 2
If I have installed MySQLDumper I get this message:
“Content-Encoding-Fehler
Die Webseite, die Sie öffnen möchten, kann nicht angezeigt werden, da sie eine ungültige oder unbekannte Form der Kompression verwendet.”
Is the code from BackWPup Version 2.1.17 with d00123.sql not compatible with the MySQLdumper code?
Thank you for help Daniel
Normally it is a SQL dump and must work. But better is to use the Version 3 for backups.
You can open the .sql file and look in if there errors. (Compre it with a Export from PHPMyadmin or MysqlDumper)
