Andrew,
I like the idea of using the crontab even though I have never used it
before. I guess the first thing I need to do is make my script. Thanks for
the link to mysqldump, I think it will be usefull. Do you happen to know
how I might be able to push a file to another server using FTP?
On Wed, 6 Oct 2004 15:31:34 -0400, Aaron Todd [EMAIL PROTECTED] wrote:
Do you happen to know
how I might be able to push a file to another server using FTP?
I might http://us4.php.net/ftp has a list of all the FTP related
PHP functions with some ready-to-use examples. Enjoy!
--
PHP
You can simply copy files from 'data' subfolder of mysql database or
create php script to make a dump of db and run it on regular basis as a
cron job.
Cheers,
Martin
What is everyone doing to backup a MySQL database. Just in case...I'd
like
to backup mine, but I was wondering if there was a
On Tue, 5 Oct 2004 16:33:08 -0400, Aaron Todd [EMAIL PROTECTED] wrote:
What is everyone doing to backup a MySQL database. Just in case...I'd like
to backup mine, but I was wondering if there was a way to do it without
going to a page and clicking a button. Is there a way to run a php script
Chris Payne wrote:
Hi there everyone,
Is there a quick way I can backup all my databases on Linux so I can download them to my HD/Burn them onto CD?
I've started a very large travel project and there is going to be over 100 DB's in the end, each with who knows how many tables and going through
mysqldump -A /path_to_file/filename.sql
for eg: mysqldump -A /tmp/alldatabases.sql
This generates a sql file which can be used as backup or for restore...
Hope it helps..
-ramki
Chris Payne wrote:
Hi there everyone,
Is there a quick way I can backup all my databases on Linux so I can
http://www.mysql.com/doc/en/Backup.html
This question might be a little bit more relevant on the mySQL-help
list... At the very least, if that page doesn't do it for you, you
might be able to get a little bit more expertise about backups of very
large installations there.
-Cameron Wilhelm
On
How'bout backing up your data directory (ies)
Otherwise you can maybe use mysql_dump in a batch??
Jack
-Original Message-
From: Chris Payne [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 26, 2003 11:46 PM
To: php
Subject: [PHP-DB] Database backup
Hi there everyone,
Is there a
use mysqldump. you can dump all databases (--all-databases) or list them
individually.
http://www.mysql.com/doc/en/mysqldump.html
hth
Jeff
Just do a mysqldump on the command line. It will dump a whole bunch of
SQL code that can be used to recreate the database in the event of
disaster. You could even pipe the output to gzip to compress it.
mysqldump --all-databases -u root | gzip -c mysql_backup.gz
That works fine for me.
10 matches
Mail list logo