RAID/MySQL configuration question

2005-08-25 Thread Curious George
G'morning all! (Using Red Hat Linux Enterprise 4.1) I have a Dell PowerEdge 2800 with a PERC 4 RAID controller. The RAID controller has one RAID 1 mirror and one RAID 5 stripe volume created. We installed most of the OS stuff on the RAID 1 set and the /usr/local and /var on the RAID 5 set (since

Moving databases from backups not working . . .

2005-12-02 Thread Curious George
Greetings all, I've got some headaches I need to make go away over the weekend. I used phpMyAdmin to backup some small mysql databases. (So I've got a bunch of _dbname_.sql files) I have a different machine with a newer version of MySQL (4.1.13a) running and configured so that I can connect from t

Re: Moving databases from backups not working . . .

2005-12-04 Thread Curious George
Thanks for the replies so far, I still haven't got this figured out, but I left out one important piece of information. I'm moving 3.23 databases to a 4.1 installation. Looking at the documentation, I see instructions for upgrading from 3.23 to 4.0 and then upgrading from 4.0 to 4.1. Does that mean

Error 1064 when importing 4.0 dump into 4.1 via command line

2006-09-26 Thread Curious George
I dumped a database from a 4.0 mysql and am attempting to move it to a server running 4.1 - using the command line: $ mysql -u root -pmypassword empty4.1db < 4.0dump.sql The result: ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL

Free chapter of O'Reilly High Performance MySQL on replication

2006-10-06 Thread Curious George
Thought this might be of interest to some on the list: http://www.oreilly.com/catalog/hpmysql/chapter/ch07.pdf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]