I want to create a cron job that does nightly backups of a database, tars
and gzips it, then ftps it to another server.
I was wondering what the perferred method of copying the data would be.
mysqldump, mysqlhotcopy or just copying the files.
=S.
-
Aravind,
MySQL stores all dates as -MM-DD, if you must use MM/DD/ then you
can store it as a string.
The best method would be to let MySQL store the date as -MM-DD and
use:
select date_format(mydate, '%m/%d/%Y');
That will return mydate as "MM/DD/".
=S.
On Tue, 26 Feb 2002
Ive seen the mysql documentation and that why I ask this question. The
docs just confuse me because the mysqldump page says mysqlhotcopy is the
preferred way, and vice versa.
The docs seem to favor mysqlhotcopy but then the page also says only to
use it when your sure data isnt being written.
It would help to see either the PHP code or the SQL statement.
=S.
On Tue, 26 Feb 2002, Edward Ionescu wrote:
> Hello,
>
> I'm using MySQL 3.23.32 and PHP. When an URL is etieved from the database,
> two things can happen:
> 1. it's working
> 2. it's not working and in look like:
> "htt
I no longer have the original post in my inbox, I had a problem with
fetchmail which downloaded all the messages a couple hundred times, so i
did a mass delete.
All you should have to do is wrap the statement in () like:
UPDATE SET field=(field+1) WHERE
This will work fine from PHP using s
