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

mysql@lists.mysql.com

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
so queries take shorter times (optimization effort) 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 #mysq

Re: MSQL Installed and running in background

2008-03-23 Thread Craig Huffstetler
ive GUI browser 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

Re: MQSQL Installed - Now what

2008-03-22 Thread Craig Huffstetler
y the way?)... And -- MySQL should 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 s

Re: MQSQL Installed - Now what

2008-03-22 Thread Craig Huffstetler
e tools: http://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: > Hel

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 oth

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 <[EM

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 comma

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 mysq

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 Sh

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 i

Re: Mysql and filesystems question

2007-10-28 Thread Craig Huffstetler
has faster write rates than 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 *

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 this

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 impo

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]> wro

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
eneral Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- Craig Huffstetler

Re: MySQL Ends Enterprise Server Source Tarballs

2007-08-13 Thread Craig Huffstetler
1&from=rss> > > &from=rss > > > > <http://www.linux.com/feature/118489> > > http://www.linux.com/feature/118489 > > > > ÐÆ5ÏÐ > > > > > > > > > -- > Eric Bergen > [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