MySQL backup function

Question

Hello all, I am writing a series of PHP functions for my site and I wanted an easy way to backup my databases however I am not sure if this will work and my server is broken at the moment (no external css files work when the file is .php but do when the files are .html) and can't test this.

Would you mind having a look at it and telling me any problems you see in it:

    //Backs up all MySQL databases and tables to 'mysql-DATE.sql' - REMEMBER TO UPDATE USER AND PASS
function backupMySQL()
{
    $date = DATE();
    $user = "root";
    $pass = "";

    $file = "mysql-".$date.".sql";

    mysqldump -u $user -p $pass --all-databases > $file
}

The parts I am most doubtful about are the file name. Thank you for your time and I hope you will be generous enough to look through the code for me. Dom Chester

Accepted Answer

1

mysqldump -u $user -p $pass --all-databases > $file

I'm not sure whether or not you're running a VPS or just have shared hosting but this definitely wouldn't work on shared, I'd suggest doing it through phpMyAdmin if you can as that's generally the easiest way of doing it, otherwise you should try doing it with a MySQL query.

answered Jun 09 '11 at 23:04

Hugo
1.7k●24●31●51

Answer 2

0

Don't really know much about MySQL, but perhaps this template can help get your external CSS showing up on your .php pages. Not sure what you've tried, or if this will help, but just thought I would try to help. :)

<?php 
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"style.css\" />"; 
?>

answered Jun 08 '11 at 12:30

jasonvstrange
16●2

Thank you for that I'll try it when I get back to my laptop.

Once again thank you.

(Jun 09 '11 at 14:27) DomChester

Answer 3

0	Ok Thank you for your help, its a localhost server but I have since set up PHPMyAdmin - It makes life so much easier!!! Thanks answered Jun 12 '11 at 05:13 DomChester 391●12●16●25

MySQL backup function

Follow this question

Related questions

Lockergnome.net

Lockergnome