Does anyone have a list of the files that need to be backed up for a
cold backup of an innodb database:
Obviously all the MyISAM files and the innodb database files. But what
about the log and archive log files?
Evelyn
Hi,
I'm a relative newbie at MySQL (Oracle DBA implementing MySQL in a
production environment). There does seem to be a lack of 'Best
Practice' documentation for MySQL in a production environment.
I opted for using both mysqldump and mysqlhotcopy. Disk is cheap and
everything is automated so
If you are always updating the entire row you could delete the record
(ignoring failures) and then insert the record. Not efficient but it
would work.
If you are able to trap errors in your shell script and there is a
unique index on the ethernet_address field then you can do this:
Update
You will need parentheses around the 'or' clauses of your where clause.
You also don't seem to join the categories table with any other tables. If you don't
join tables you will create what is called a 'cross product' query. If table A has 10
rows and table B has 20 rows then querying A
= l.CategoryID
This goes in the WHERE clause, right?
Thanks!
-Erich-
-Original Message-
From: Schwartz, Evelyn [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 8:53 AM
You can try the 'show table status' from mysql. There is an update_time that lists
the last modified date for the table.
I also found out that these types of commands work with perl DBD::mysql. You can
treat the command like a normal sql statement and the results are returned like any
Just went through this.
You need to install MySQL from source.
The basic commands you must execute to install a MySQL source
distribution are:
shell groupadd mysql
shell useradd -g mysql mysql
shell gunzip mysql-VERSION.tar.gz | tar -xvf -
shell cd mysql-VERSION
shell ./configure
Yes, you have to move the mysql and test databases - only one directory
for all files.
Shut down mysqld
Modify the my.cnf
Move the data files
Start up mysqld
You might want to check the /etc/init.d/mysqld file - the path is hard
coded there.
-Original Message-
From: Patrick Fowler
We are implementing three or four MySql servers (as a start) and I'm
writing the Troubleshooting Guide for our operational staff. None of
these folks have any MySQL experience (and I'm a newbie myself). I need
a pretty basic 'Cheat Sheet' for troubleshooting common production type
problems.
The