Re: MySQL DB Version

2010-10-05 Thread Craig Huffstetler
 How can we get our MySQL db upgraded to this version or greater ? You can also find these at: http://dev.mysql.com/downloads/ Cheers, Craig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MYSQL

2008-08-26 Thread Craig Huffstetler
://www.ucl.ac.uk/is/mysql/c/ http://www.tutorialized.com/tutorials/C-and-Cpp/1 http://www.planetmysql.org/entry.php?id=14437 http://www.cyberciti.biz/tips/linux-unix-connect-mysql-c-api-program.html MySQL itself is in fact in written in C and C++! I hope this helps some. Cheers, Craig Huffstetler

Re: Query execution time - MySQL

2008-05-14 Thread Craig Huffstetler
) to execute a little bit more about your MySQL database setup and machine(s) would be beneficial to us as well. )) Let me know if you have any questions. Standing by and I hope this helped you. Sincerely, Craig Huffstetler xq on FreeNode #mysql | #apache On Wed, May 14, 2008 at 6:13 AM, Neil Tompkins

Re: MSQL Installed and running in background

2008-03-23 Thread Craig Huffstetler
interfacing with your database tables. Just read into it. Craig Huffstetler / xq on FreeNode IRC On Sun, Mar 23, 2008 at 12:05 AM, AndrewMcHorney [EMAIL PROTECTED] wrote: Hello I have successfully install mysql and is is running in the background as a service ( I believe) as in msconfig lists

Re: MQSQL Installed - Now what

2008-03-22 Thread Craig Huffstetler
://dev.mysql.com/downloads/gui-tools/5.0.html Check out that page for further information and download links. I hope this helps. Sincerely, Craig Huffstetler xq on FreeNode IRC network On Sat, Mar 22, 2008 at 4:49 PM, AndrewMcHorney [EMAIL PROTECTED] wrote: Hello I just successfully installed

Re: MQSQL Installed - Now what

2008-03-22 Thread Craig Huffstetler
AUTO START when you load Windows. Is it not automatically starting up? Sincerely, Craig Huffstetler xarquid on FreeNode IRC On Sat, Mar 22, 2008 at 7:28 PM, AndrewMcHorney [EMAIL PROTECTED] wrote: Hello I have never added something to startup. How do you do it? What is the default (application

Re: 64bit to 32bit

2008-03-21 Thread Craig Huffstetler
, I know). Good luck with the upgrade. Sincerely, Craig Huffstetler On Fri, Mar 21, 2008 at 6:44 PM, Ed Wildgoose [EMAIL PROTECTED] wrote: Hi, what issues should I watch out for if I upgrade one machine in my master-master mysql 5.0 replication pair to a 64bit machine (the other remains

Re: Server Instance Setup Error

2008-03-09 Thread Craig Huffstetler
Greetings Andrew, Make sure you have granted access to your user: (run command line) mysql GRANT ALL ON databaseName.* TO 'your_mysql_name'@'your_client_host'; Sincerely, Craig Huffstetler P.S. - What version of MySQL, what operating system and are you using the command line (I was assuming

Re: Server Instance Setup Error

2008-03-09 Thread Craig Huffstetler
assuming this is where the error is occurring), then start-up MySQL? This error generally occurs when a user attempts to login. We may need some more details to troubleshoot this. Can you please re-run the install. Sincerely, Craig Huffstetler On Sun, Mar 9, 2008 at 6:12 PM, AndrewMcHorney [EMAIL

Re: Can't drop database that shows up in show databases

2008-03-08 Thread Craig Huffstetler
Waynn: What user are you using to execute mysql from the command line? Perhaps run mysql (from command line) as root then execute the desired actions (such as drop). This will make sure you can drop the table and avoid any further problems. Sincerely, Craig Huffstetler On Sat, Mar 8, 2008 at 6

Re: Oracle is acquiring...............................

2007-11-26 Thread Craig Huffstetler
Like Falcon? Yes, Falcon is a great piece in the MySQL arsenal if you ask me (or probably any MySQL devotee). Cheers, Craig Huffstetler On Nov 26, 2007 8:06 AM, Martijn Tonies [EMAIL PROTECTED] wrote: I am little bit worried about the mysql future and me too. Oracle has acquired

Re: mysql dump

2007-11-13 Thread Craig Huffstetler
No, but a table lock or two may be expected. This is to PREVENT data loss (which you were also worried about). The mysqldump process will most likely be quick and painless (quick being a relative term, depending on the amount of data in your database(s)). Craig On Nov 13, 2007 2:35 PM, Naufal

Re: Post Installation for Mysql on Ubuntu

2007-10-29 Thread Craig Huffstetler
sudo apt-get install mysql-server Should install it. It will even create the user account for you... http://www.supriyadisw.net/2006/12/lamp-installation-on-ubuntu Has further information. Scroll down to MySQL. On 10/29/07, Tim Johnson [EMAIL PROTECTED] wrote: Hello: I am preparing to

Re: Mysql and filesystems question

2007-10-28 Thread Craig Huffstetler
reiserfs. Craig Huffstetler wrote: I agree, Fedora is not very good at production work. Reiserfs is one of the best file systems I have come across for MySQL Production. On 10/28/07, *B. Keith Murphy * [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: In production we use both

Re: High Traffic Sites

2007-10-22 Thread Craig Huffstetler
I highly recommend you hire a consultant or a freelance DBA to try to work this out. You are talking about something pretty extensive. I would recommend replication across quite a few high-end servers (all 64 bit of course with plenty of RAM). Clustering can be a pretty big headache. A lot of

Re: server optimization

2007-10-19 Thread Craig Huffstetler
Can you send us a copy of your my.cnf at the moment. Also, if you can provide some reports that will help us determine the best functionality, that would also help a lot. It is useful to know what is getting read/writing (or which function is being requested the most...). Table format is also

Re: importing a single table from mysqldump

2007-10-19 Thread Craig Huffstetler
A little bit easier of a way to do this could be the following command: mysql -u[user] -h[host] -p [database] [mysql dump file] Make sure the database you're importing into is EMPTY (or at least the TABLES you are importing to are empty...) On 10/19/07, Werner Van Belle [EMAIL PROTECTED]

Re: Synchronizing two MySQL servers over slow network

2007-08-25 Thread Craig Huffstetler
I would probably recommend replication. It's not that bad to setup and once it catches up on the slave then it will continue to be an easy sync in the future as long as both are running. How big is the database you wish to synchronize? What connection are both servers on? Is there anyway possible

Re: Enterprise Wide Deployment

2007-08-14 Thread Craig Huffstetler
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Craig Huffstetler

Re: MySQL Ends Enterprise Server Source Tarballs

2007-08-13 Thread Craig Huffstetler
[EMAIL PROTECTED] http://www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Craig Huffstetler