Backup Mysql with PHP

[53329]

I've tried a few classes to do it but none seem to work.  Is there a script out there that lets you backup certain tables?  I have a few that have over 10,000 rows in them so whenever I try to backup the whole thing with someone else's script the file either clips the last few tables or it just gives me a corrupt file.

[ratcateme]

can't you right your own script it is not that hard.

 

Scott.

[53329]

Any useful functions I might need in that case?  I just found out that my largest table has ~50k rows in it.

[xtopolis]

Google.

Results 1 - 10 of about 1,620,000 for php mysql backup. (0.13 seconds)

[53329]

I've spent the last 9 and a half hours trying scripts like that but none have worked.  Like I said my database is absolutely massive.  The small tables at the beginning (alphabetically) always work but then they break as soon as they get to the first big one.

[tibberous]

10,000 rows isn't really massive - it's big, but I had a table with 5.4 million rows - it took me 5 days to make.

 

Anyway, you don't need a script, you can do everything you need to using mysql and mysqldump from the command line.

[53329]

That might work.  Only problem is that I've never had to use command line before.  Can you do that only using PHP?

[ratcateme]

look up exec()

 

Scott.

[tibberous]

Yeah, use can use exec, passthru, shell_exec, ``, ect.

 

To make debugging easier, I like to use full paths and Putty - once you get the command working in Putty, just paste it into your exec call.

[53329]

I tried using putty but it freezes right after I input who to login as.

 

I also tried another script

 

system(sprintf(
    'mysqldump --opt -h %s -u %s -p%s %s | gzip > %s/%s/%s-%s%s%s-%s%s.gz',                                                 
    $host,
    $user,
    $pass,
    $db,
    getenv('DOCUMENT_ROOT'),
    $backupdir,
    $db,
    $year,
    $month,
    $day,
    $hour,
    $min
  )); 

 

But it gave me less that a tenth of the db.  Also I think my host disabled using exec, passthru, etc as they don't work.

 

Right now I think the only approach might be to first take the structure for all the tables then somehow do partial backups of the data in the tables.  It seems a but ridiculous though as the total size of the database is only about 10-20 megs.

[ratcateme]

did you look at the first result on google

http://www.php-mysql-tutorial.com/perform-mysql-backup-php.php

the second example looks good to me if your hosting has disabled exec and possiable limited system

 

Scott.