MysqlDump destination file

Hi! I'm a newbie trying to use the backup\dump command. My questions are: 1. When using the command "mysqldump --single-transaction --quick -uroot -p --all-databases", what is the default destination path (server\volume\folder) and the default file name? 2. If using a redirection " > destinatio

Re: installation nightmare

Hi PJ, To be quite honest you may have better luck downloading and installing MySQL yourself. It's very rare I install anything from the ports on FreeBSD or apt repositories on Debian, simply because you have little (if any) control over what goes on. At least if you do it yourself you know

installation nightmare

Or should I say 4-day-mare... I have been trying to set up mysql for the last 4 days with weird success. I first installed mysql 6.0.8alpha not knowing I needed 5.0 compatibility for my ISP Website host. I go everything working pretty well... mysql6, php5, phpMyAdmin, all on FreeBSD 7.0 with ap

Hypothetically looking for Kevin Bacon

Hello mysql list, I am looking for a little guidance on a a potential query. I am sure most people have heard of the limited degrees of separation one has to become connected to another person. This is much like the myspace "in your extended network" idea, though I would like my implement

select

Hi all, I would like how to function select working internals. If each select in BD is mono process or various select is processes in same time without lock table? Tks Marcos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

[ANN] PBXT 1.0.07 RC Released!

Hi All, I have just posted the first Release Candidate version of the PBXT transactional storage engine for MySQL. For more information on PBXT, please check out the home page: http://www.primebase.org My blog has a some more details on the release: http://pbxt.blogspot.com/2008/12/pbxt-go

Trying again, SSL between client and server using SslOption/mysql_ssl_set ( C++/C )

I have a few questions about the parameters for SslOption/mysql_ssl_set ( C++/C ) and about SSL in general between the server and the client. I do understand what a certificate, a private key, and a public key is in general but I am having trouble understandng how they work in MySql. 1) Are the f

Re: stuck on a query

Now that was fun and educational. :-) I like the third approach, but theres an added problem to the whole thing. This query is just a part of a bigger search. The tables, job and color and other fields, which will also be searchable. I am trying to automate the whole process, i mean, the user see

undefined reference to `mysql_bind_param'

Hi, I have installed MySQL 6.0.6-alpha on Redhat Linux. I have copied the example program from http://teaching-.cs.uml.edu/MySQLdocs/MySQL_Manual/mysql_execute.html and compiled as follows. gcc -o insert_by_bind -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient -lz -lrt -lcr

Re: Table Lock

Hi! sangprabv wrote: > Hi, > Is that true that MySQL lock table on each query? Does it means will > cause slow speed? Then how to avoid table lock and speed up MySQL? TIA. You need to read up about the different table handlers available. They have different properties, including the locking beh

Table Lock

Hi, Is that true that MySQL lock table on each query? Does it means will cause slow speed? Then how to avoid table lock and speed up MySQL? TIA. Willy The Public is merely a multiplied "me." -- Mark Twain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc