Re: Alter table command don't work

be able to copy it using an INSERT SELECT (not sure though, haven't had to do it) Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: MySQL commercial licence

one by default. How many people actually check on that before purchase? Are they aware they have purchased a GPL product and are now obligated under that license to GPL their distributed products? Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream

Re: Unidata to Mysql

); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- David Logan South Australia when in trouble, or in doubt run in circles

Re: Should we petition GoDaddy?

or close your account because of the high processing load needed to push that much traffic. Who is GoDaddy and should I care? Is this an international issue? Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List

Re: mysqldump

? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Hi, From the manual, http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html use -A or --all-databases as an option Regards David Logan South Australia When in trouble, or in doubt Run in circles, scream and shout

Re: Tuning a Server with 10,000 databases

. Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Very large from

. First page does a insert to create the row, then following pages do updates to complete populating the row with data. Has anyone done anything like this or have seen this done before. What advice can you offer. Where to look for examples. Thanks -- David Logan South Australia when

Re: error 1016 : cant open ibd file even though it exists

://lists.mysql.com/[EMAIL PROTECTED] -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout

Re: Surviving MySQL crash

* * * * /usr/local/mysql/bin/mysql -u root -pxx -e 'FLUSH TABLES' This would run a FLUSH TABLES once every hour at 15 minutes past. If you are using Windows, sorry I'm not sure how to do it there. Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout

Re: Connection problem after long idle periods

Michael, Try looking at http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html more specifically the connect-timeout variable. You should use SHOW VARIABLES LIKE %connect%; and check the value. It maybe this and you can stretch it out further if you need to. Regards -- David Logan

Re: setting the data directory.

datadir=/path/to/mysql/stuff to the my.cnf file and it will point to there. Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout

Re: mysqldump: Got errno 32 on write ?

--- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED

Re: Can i get a mysql technology standard

well described in the section http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html along with any special features and/or limitations. Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives

Re: rentering a sql script

, especially the IF NOT EXISTS bit. This will allow you to bypass the CREATE DATABASE requirement. You may also use a similar syntax for the CREATE TABLE statement. Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout

Re: Error 1013

info is available at http://dev.mysql.com/doc/refman/5.0/en/load-data.html Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Error 1013

Karl Krelove wrote: David Logan wrote: Karl Krelove wrote: I'm trying to import a large amount of data from an Access database containing information about 9,000+ students in a school system. I've created a table 'student_list' to hold the data and issued the following command: LOAD

Re: user to start/stop mysql without db access?

, then consider using sometbing like sudo or ssu to allow the other user access to the startup/shutdown script only. sudo can be found at http://www.sudo.ws/sudo/ not sure where ssu comes from though. Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout

Re: Help! Problem moving MySQL data dir to a larger file system

for us. -- Dan Mahoney [EMAIL PROTECTED] How you behave towards cats here below determines your status in Heaven. Robert Heinlein There are two means of refuge from the miseries of life - music and cats - Albert Schweitzer -- David Logan South Australia when in trouble

Re: Failure to install on Solaris.

fashion Regards David -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Where did my disk space go?

For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- David Logan South Australia when in trouble

Re: Installer for 4.0.13

://downloads.mysql.com/archives.php?p=mysql-4.0o=solaris Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout

Re: Need help in locating configuration file

! Mail SpamGuard. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout

Re: mysql client update

that informs all clients that a new record has been added for example. Thanks in advance. Regards Hi, Triggers were added at 5.0.2 They have some limitations but are documented in the manual at http://dev.mysql.com/doc/mysql/en/create-trigger.html Regards -- David Logan South Australia when

Re: backup a database

by cron and should be set in your shell script. Cron starts with only a couple of variables set and you have to start everything else. Are you getting any output from the cron daemon? It should be in the logs somewhere or else emailed to root. Regards -- David Logan South Australia when in trouble

Re: Can't read database

be owned/group mysql. If the permissions are correct, then you need to check the .frm file hasn't disappeared for the table. If it has then you need to follow the instructions at http://dev.mysql.com/doc/mysql/en/repair.html, I think you may have reached stage 4. Regards -- David Logan South

Re: RES: phpmyadmin can't connect via browser

://dev.mysql.com/doc/mysql/en/index.html http://www.php.net http://www.phpmyadmin.net The docs are most comprehensive and go over everything you have noted above. Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list

Re: Tables,

exactly what you are trying to do, this is an open source product and you get many, many examples of your request. Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Url http://highperformancemysql.com/

guess they should have written a book on high security mysql instead? John A. McCaskey Hi, I just tried http://www.highperformancemysql.com and it works fine. You can also try http://jeremy.zawodny.com/mysql/ Regards -- David Logan South Australia when in trouble, or in doubt run in circles

Re: MySQL database and user creation from script file

/index.html Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]