WebmasterSite.net

Backup Database no error but backup.sql

Version: 5.1.0 Beta 13
URL:

PrintPrint


Backup Database no error but backup.sql
frankbeckers
Forum Regular

Usergroup: Customer
Joined: Dec 20, 2007
Location: Germany

Total Topics: 33
Total Posts: 106
quote post #1
Posted 08/30/09 - 12:30 PM:

Hi Paul,

Backup Database writes "The backup file has been generated." but backup.sql has a size of 0KB (empty) and a timestamp from now.

Thanx,
Frank
Paul
developer
Avatar

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 65
Total Posts: 7614
quote post #2
0 of 1 people found this post helpful
Posted 09/01/09 - 12:55 AM:

Not reproducible, backups write fine here.
frankbeckers
Forum Regular

Usergroup: Customer
Joined: Dec 20, 2007
Location: Germany

Total Topics: 33
Total Posts: 106
quote post #3
Posted 09/11/09 - 2:09 PM:

Do you have any tips for me for tracing or debugging this sitution. Changing the "Debug Level" don't help me an further.
Paul
developer
Avatar

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 65
Total Posts: 7614
quote post #4
Posted 09/11/09 - 6:59 PM:

If your host's security settings prevent doing backups, I added a notice to explain that a couple betas ago.

If you're in apache mode without suPHP, it could be an admin directory permissions issue.

Maybe it's possible for mysqldump to not be on the server, or to not be accessible without some sort of absolute path, but I doubt it.

Otherwise, as always, site inspection service is the easy way to tell.
frankbeckers
Forum Regular

Usergroup: Customer
Joined: Dec 20, 2007
Location: Germany

Total Topics: 33
Total Posts: 106
quote post #5
Posted 05/06/10 - 11:05 AM:

DB backup ist still not working in 5.1.33 Beta 7, so the db overwritten problems mentioned in another thread arem hardly to handle. Is there any chance to analyse this issue again?
Paul
developer
Avatar

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 65
Total Posts: 7614
quote post #6
Posted 05/07/10 - 3:20 PM:

The only way I can tell you what's going on is if you let me have a look at it: http://www.wsnlinks.com/inspection.html

It's not a generic issue, it's specific to your server configuration.

It is a *nix host and not in safe_mode?
Paul
developer
Avatar

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 65
Total Posts: 7614
quote post #7
Posted 05/11/10 - 2:16 AM:

The issue was the mysql socket specified in your host name: "localhost:/tmp/mysql5.sock". While php's mysql_connect can process that, the mysqldump command line utility can't handle socket specification in the host name and needs it in a separate -S parameter. I've changed WSN's backup utility so that it splits off the socket into the separate parameter, and it works for you now.
 
Search thread for
Download thread as


Sorry, you don't have permission to post. Log in, or register if you haven't yet.