Thanks MtDewVirus!!
@karl: If you are still with me, try this:
Find this line (in 4 places) in backupRestore.php:
require_once (‘./admin-header.php’);
and replace with this line:
require_once (‘admin-header.php’);
Hi there,
I’m still here 🙂
I am getting the same error:
Warning: main(admin-header.php): failed to open stream: No such file or directory in /home/public_html/backup/backupRestore.php on line 132
Fatal error: main(): Failed opening required ‘admin-header.php’ (include_path=’.:/usr/lib/php:/usr/local/lib/php’) in /home/public_html/backup/backupRestore.php on line 132
thanks
Karl
Karl,
backupRestore.php needs to be in your wp-admin folder with this new version. From the error it looks as if you might have it in a folder called “backup”.
😛 Sweet! I missed that backup folder thing as well! Thanks MtDewVirus!
Karl,
I backup my folder and database every few days, download the backups from the server and then delete them to save space. If I ever need to restore I’ll just upload the sql file first. 🙂
sighz, my server doesn’t have mysqldump in the path and I do not know the path =(
I tried
/usr/bin/mysql
/usr/lib/mysql
/usr/share/mysql
/usr/share/man/man1/mysql.1.gz
all doesn’t work
Karl, unless you upload a lot of stuff (like pictures, add hacks etc) to your blog, the files do not get changed much. Thus a file backup is not necessary all that often. There are ways to force a download of the file and then delete it off the server, but I did not think that would be as useful. Just as MtDewVirus suggested, download the backups to your local computer and delete them off the server when they get too large in numbers.
Hi Nick and LaughingLizard (sorry don’t know your name :)),
That makes good sense.
Thanks again.
Karl
@laughinglizard:
which mysql gives me : /usr/bin/mysql. so the dump is at /usr/bin/mysqldump ?
@gamerz: I am sorry, I should have said:
<?php
echo passthru(“whereis mysqldump”);
?>
Normally mysqldump is in the same search path as mysql. Try running the which mysqldump or whereis mysqldump.
@laughinglizard: For some reasons whenever I run passhtru or exec, it will give me The page cannot be displayed
@gamerz: passthru (and other system exec commands) will not work when php is running in safe mode. The command will only execute programs which are physically located in the folder specified by the safe_mode_exec_dir directive.
If your server is running in safe mode, you could try to make a folder in your web directory and put all the mysql binaries into it. Then add this line to your .htaccess:
php_value safe_mode_exec_dir “/folder/where/mysqldump/is/localted”
However, I checked with your server and it is not running in safe mode. So, if you are still with me, find this line in your backupRestore.php:
echo passthru(“mysqldump –opt -h$server -u$loginsql -p$passsql $base >$file_name”);
and replace it with this one. Let me know if it works and I will fix the hack to reflect all of the passthru functions.
system(“mysqldump –opt -h$server -u$loginsql -p$passsql $base >$file_name”, $retval);
echo $retval;
At some point, I’ll look into just dumping the database through PHP, without the need for mysqldump… it’s pretty easy, especially given my database-to-database backup works by dropping and inserting the data. All you need is the database template in place — but I should be able to somehow grab the schema of all the tables too, and then loop through the tables. Mark, we should catch up on this idea at some point… 😉
-d
http://www.chait.net
I agree with you David. As a matter of fact, I was working on the php walkthrough of the databases to produce an sql export for an upcoming release. If you already have that done (or some part of it) we should collaborate.
The only issue is that the export has to be mysql import compatible. (or we can write a custom import script as well) The wonder of mysqldump is that the tables and all columns (and their features) are created automatically. However, considering the fact that a restore would be done after a vanilla install of wordpress, that is a non-issue.
