Utf-8 in 4.1
Hello, 4.1 version can use UTF-8 encoding, but as far I remember there is something wrong with this feature. Can you tell us when 4.1.1 version will be released and is it will be fixed. Best regards, Marek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Charset=latin1 problem
Hello
I have two MySQL 4.1 servers installed. One at home
and at my work. Both run WinXP.
I used mysqldump to export my database at work and
tried to import it at my home server, I am getting the
following error in one of the - create table
defintaion
Error Code : 1064
You have an error in your SQL syntax near
'CHARSET=latin1 ROW_FORMAT=DYNAMIC
COMMENT='Inneholder abonnementdata'' at line 38
(113 ms taken)
The create table query is as follows
CREATE TABLE `abonnenter` (
`id` int(11) NOT NULL auto_increment,
`navn` varchar(100) NOT NULL default '',
`abonr` varchar(20) NOT NULL default '',
`adresse` varchar(50) NOT NULL default '0',
`post` varchar(50) NOT NULL default '0',
`telefon` varchar(20) default NULL,
`telefax` varchar(20) default NULL,
`epost` varchar(100) default NULL,
`web` varchar(50) default NULL,
`kp_navn` varchar(50) NOT NULL default '',
`kp_telefon` varchar(20) NOT NULL default '',
`kp_epost` varchar(50) default '',
`abbtype` varchar(10) NOT NULL default '0',
`tdato` date NOT NULL default '-00-00',
`kresp` enum('J','N') NOT NULL default 'N',
`passord` varchar(20) binary NOT NULL default '',
`sdato` datetime NOT NULL default '-00-00
00:00:00',
`sist_innlogget` datetime NOT NULL default
'-00-00 00:00:00',
`kandidat_brukernavn` varchar(30) default NULL,
`skifte_passord` enum('TRUE','FALSE') NOT NULL
default 'FALSE',
`po_spm` varchar(100) NOT NULL default '',
`po_svar` varchar(100) NOT NULL default '',
`visinfo` enum('TRUE','FALSE') NOT NULL default
'TRUE',
`regdato` datetime NOT NULL default '-00-00
00:00:00',
`selgernr` varchar(30) NOT NULL default '',
`status` varchar(30) NOT NULL default 'Aktiv',
PRIMARY KEY (`id`,`abonr`),
UNIQUE KEY `abonr` (`abonr`),
UNIQUE KEY `id` (`id`),
UNIQUE KEY `abonr_index` (`abonr`),
UNIQUE KEY `kandidat_brukernavn_index`
(`kandidat_brukernavn`(10)),
KEY `id_2` (`id`),
FULLTEXT KEY `navn` (`navn`),
FULLTEXT KEY `navn_2` (`navn`),
FULLTEXT KEY `navn_3` (`navn`)
) TYPE=MyISAM CHARSET=latin1 ROW_FORMAT=DYNAMIC
COMMENT='Inneholder abonnementdata';
When I try to exeucte it at my work office, everything
works fine?
Why the anomaly? Is my home MySQL configuration
missing something?
Even this query is returning me error -
CREATE TABLE `aboutvidelser` (
`id` int(11) unsigned NOT NULL auto_increment,
`abonr` varchar(20) character set latin1 NOT NULL
default '0',
`udato` datetime NOT NULL default '-00-00
00:00:00',
`abotype` char(1) character set latin1 NOT NULL
default 'O',
`antall` smallint(5) unsigned NOT NULL default '0',
`selgerid` int(11) unsigned NOT NULL default '0',
`stat` enum('aktiv','slettet') character set latin1
NOT NULL default 'aktiv',
`slettetdato` datetime NOT NULL default '-00-00
00:00:00',
PRIMARY KEY (`id`),
KEY `abonr_index` (`abonr`),
KEY `selgerid_index` (`selgerid`)
) TYPE=MyISAM;
The error returned for the above case is -
You have an error in your SQL syntax near 'character
set latin1 NOT NULL
default '0',
`udato` datetime NOT NULL default '' at line 4
Thanks in advance.
Karam
__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql ssh tunneling
On Sun, May 25, 2003 at 12:09:33PM +0200, Tobias Schittkowski wrote: I established the tunneling connection, and a mysql -h localhost -u foo -pbar mysql connects me nicely to the server. However, if I use the mysql_real_connect(...) the host hangs. What host are you using? Try running your tunnel with ssh -ddd for extra debugging output on tunnel creation -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Have some problem with Ver 4.0.13
Hi. I used MySQL for over 2 years since ver 3.22 and now use ver 3.23.49 Z9bundle with RedHat 7.3) it work fine and now I decide to upgrade to ver 4 (as production cersion) I download ver 4.0.12 but when I will start to upgrade the new one 4.0.13 launch so I decide to up to 4.0.13 instead of 4.0.12 and install on RedHat 9.0 My problem is when I run query with very simple query the MySQL server often lost connection. (Error 2013 lost connection ...) so I try to install new with 4.0.12 it never get error it work very fine and never get error what happen with 4.0.13. I used to know the same problem occur on RedHat 8 that how to solve is add the line set-variable=thread_stack=256k in my.cnf ( I use with RedHat 8 it work so I try this with RedHat 9 it not work) Now I normaly use RedHat 9 and MySQL 4.0.12. Thanks Kittiphum Worachat. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with load from file
We, ok. Thank you all. This worked quite nicely and I learned something to boot! TR On Tuesday, May 27, 2003, at 11:00 PM, Steve Gums wrote: The numbers should be without the quotes and the end of line character can stay as is. Once you have this you should be able to do something like this. load data local infile 'path to infile' into table table name fields terminated by ',' optionally enclosed by ''; This is what I used and it worked very well. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 8:31 PM To: MySQL List Subject: Re: help with load from file I also have it prepared like this: 1,Mac,SE30,314784,LOV,115,,, 2,Mac,Performa6300CD,338211,LOV,109,,, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Just a doubt.....
Hi, I made a table with a primary key,and all the columns i declared char got converted into varchar. plz someone throw a light on it as i had seen somewhere that using primary key increase search speed and using varchars decrease so im in confusion. :( -- harsh http://www.cse.iitb.ac.in/~harsh -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql crashe-binary logs
Hello, I use mysql 3.23.49 on Solaris and I have started binary logging.. I had no problem for quite a long time but the last days I see this message in the error log file mysqld restarted /usr/local/mysql/libexec/mysqld: ready for connections Any idea why this is happening? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Just a doubt.....
Hi, I made a table with a primary key,and all the columns i declared char got converted into varchar. plz someone throw a light on it as i had seen somewhere that using primary key increase search speed and using varchars decrease so im in confusion. :( http://www.mysql.com/doc/en/Silent_column_changes.html: 6.5.3.1 Silent Column Specification Changes In some cases, MySQL silently changes a column specification from that given in a CREATE TABLE statement. (This may also occur with ALTER TABLE.): VARCHAR columns with a length less than four are changed to CHAR. If any column in a table has a variable length, the entire row is variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer than three characters are changed to VARCHAR columns. This doesn't affect how you use the columns in any way; in MySQL, VARCHAR is just a different way to store characters. MySQL performs this conversion because it saves space and makes table operations faster. See section 7 MySQL Table Types. Leander -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: User Variables doesn't work?
Thanks for your info, I d/l SQLyog and it seems really cool. MySQLFront 2.5 had so many bugs that I had to leave it. I prefer SQLyog now. Its FREE !!! and has all the features ( plus some realy cool extra features ). You can try SQLyog at http://www.webyog.com/sqlyog Karam --- Peter Brawley [EMAIL PROTECTED] wrote: Not just MySQLFront. PhpMyAdmin chokes on it, too. - - Original Message - From: ML To: [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 9:08 AM Subject: Re: User Variables doesn't work? You are right, I tried from command line and it works, the problem occurs with MySQL Front v2.5. This is strange because I love this software and this is a strange bug... Regards. I'm using User Variables, I tried it with the query found in the mysql manul: SELECT @t1:=(@t2:=1)[EMAIL PROTECTED]:=4,@t1,@t2,@t3; But I receive this error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(@t2NULL1)[EMAIL PROTECTED],@t1,@t2,@t3' at line 1 I have MySQL v4.0.12 Worked perfect for me. Did you execute the above query from command-line client or what client did you use? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- MySQL General Mailing List 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]
mysqldump suddenly returns error 1064
Hi all, I hope this isn't an obvious question, but I'm having a hard time figuring this one out. I have a cron job set up to run mysqldump regularly to dump my databases out to a flat file, which is then compressed and passed to our backup server by another script. The cron job runs the command: mysqldump -Aac --add-drop-table --all-databases --opt /tmp/mysqldump This had been working fine for ages. However, now I'm getting an error every time it runs, indicating that there's a problem with the SQL syntax - however, this is the SQL being written out by mysqldump, and nothing on the server has changed which I would expect to cause this - MySQL hasn't been reconfigured or upgraded or anything. The error I'm seeing is: mysqldump: Got error: 1064: You have an error in your SQL syntax near '404 READ /*!32311 LOCAL */' at line 1 when using LOCK TABLES Just for info: MySQL v3.23.51 on Slackware Linux 9.0 (on a high-performance dual-Xeon server). Anyone got any ideas what could be causing this to happen? Many thanks David P -- David Precious [EMAIL PROTECTED] http://www.preshweb.co.uk A clear conscience is usually the sign of a bad memory -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hostname-bin.xxx file what is this
I installed MySQL that comes with RedHat 8, after run it I noticed that lot of file created in my data directory, file name is something like 'myhostname-bin.xxx' where xxx is the number, and it take lot of disk space. What the file is use for and how to avoid it? Thanks in advance. _ Using a handphone prepaid card? Reload your credit online! http://www.msn.com.my/reloadredir/default.asp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Copy Database?
Hi mysql list, I have a a database lest say called test which is about a gig in size. I want to take a copy of that database and call it test2 and have it running on the same server. I could just do a dump and then insert the dump back in but this seems a rather long way of doing it. I had a search on the mysql.com site but can't find anything. Any ideas? Cheers John Wards SportNetwork.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication with non permanent connection
Hi all I'm going to setup a mySQL database that has to be accessed from Asia and Europe. Due to the huge distance I plan to duplicate the database and store one copy both in Europe and Asia. To achive data consistency both databases has to synchronize each other. Because of the long distance a disconnect for several hours is possible (worst case). Is database replication an adequate solution for synchronizing the databases or is there maybe a better way? How does mySQL replication handle disconnects in respect to the synchronization? Thanks for your support Cheers Kristian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Copy Database?
I have a a database lest say called test which is about a gig in size. I want to take a copy of that database and call it test2 and have it running on the same server. I could just do a dump and then insert the dump back in but this seems a rather long way of doing it. I had a search on the mysql.com site but can't find anything. If you are using MyISAM tableas and can stop the server, you can simply copy the directory test in the mysql data directory to test2. You should not do this while the server si running because mysql caches data and the files may not be up-to-date. If you are using another table type, you could look at the CREATE TABLE SELECT command. Alec Cawley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
database permissions
What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. Thanks. Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication with non permanent connection
I'm going to setup a mySQL database that has to be accessed from Asia and Europe. Due to the huge distance I plan to duplicate the database and store one copy both in Europe and Asia. To achive data consistency both databases has to synchronize each other. Because of the long distance a disconnect for several hours is possible (worst case). Is database replication an adequate solution for synchronizing the databases or is there maybe a better way? How does mySQL replication handle disconnects in respect to the synchronization? 1. Yes 2. Well Check the archive of this list - several people have reported doing similar things. E.g. replicating a net-connected database to a slave over a dial-up which connects only every few hours. Replication attempts to connect regularly. If connection fails, replication does not occur, When the connection reappears, the slave smoothly catches up. Have you solved the update problem? Remember that all updates must go to the Master, and then be replicates to the slave. Is Europe or Asia the master copy? Alec Cawley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem with phpMyAdmin authentication
Hi All, I have a problem with phpMyAdmin authentication feature. I've setup the cookie authentication feature for phpMyAdmin as explained in the manual. It works perfectly on my PC with easyphp. But when I've done the same thing on my Cobalt RaQ4 server, I get a pop-up asking for the login/password FOR THE SERVER, before getting to the screen where I'm asked for the phpMyAdmin login/password. Is there a way to get rid of this pop-up? Thanks, Didier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database permissions
oops, oh yeah. I fixed it. TR On Wednesday, May 28, 2003, at 05:56 AM, [EMAIL PROTECTED] wrote: What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. Thanks. Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database permissions
* [EMAIL PROTECTED] What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. On my system the mysqld deamon runs as mysql and files are owned by mysql. -- Jon Haugsand, [EMAIL PROTECTED] http://www.norges-bank.no -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(2014) Commands out of sync; You can't run this command now
MySql, Hope you can help. I'm suddenly, after updgrading to MySQL 4.0.13-max-log Linux, getting the error: (2014) Commands out of sync; You can't run this command now On the second command I send to MySQL. First, no problem. I'm using MyC libruary, which has worked before. Various pages on the Internet surgest I use a mysql_connect() instead of mysql_pconnect() to fix this. However, MyC seems to use: mysql_real_connect (mysql, host, name, pass, db, 0, NULL, 0) To which I cannot find any logical fix. There are lots of quotes of this error in, say, Google, but no reason or fixes I can find. I can disconnect and reconnect for every query, which does work, but is not a great idea. Can any member surgest anything I might be able to use? Thanks, ben. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Copy Database?
John Wards [EMAIL PROTECTED] wrote: I have a a database lest say called test which is about a gig in size. I want to take a copy of that database and call it test2 and have it running on the same server. I could just do a dump and then insert the dump back in but this seems a rather long way of doing it. I had a search on the mysql.com site but can't find anything. You can use CREATE ... SELECT statement: http://www.mysql.com/doc/en/CREATE_TABLE.html but you should create indexes manually. You can also change output of SHOW CREATE TABLE test and change table name to test2 and then use INSERT .. SELECT statement. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: hostname-bin.xxx file what is this
Knight Raider [EMAIL PROTECTED] wrote: I installed MySQL that comes with RedHat 8, after run it I noticed that lot of file created in my data directory, file name is something like 'myhostname-bin.xxx' where xxx is the number, and it take lot of disk space. What the file is use for and how to avoid it? They are binary log files: http://www.mysql.com/doc/en/Binary_log.html If you want turn off binary logging just remove log-bin entry from my.cnf -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: multiple unique updates
Andrew Hazen [EMAIL PROTECTED] wrote: Does anyone know a way to do multiple unique updates in one query, the way you can in an insert query? I have a table with several thousand records. Periodically every record in this table needs one field to be updated. Slows down the process if each record is updated with a separate query. You can use UPDATE with WHERE clause, or may be REPLACE is a solution for you. Could you explain your problem more detailed? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: load infile problem
jsmurthy [EMAIL PROTECTED] wrote: Hi All, Iam facing the problem in MySql Load infile MySql - Version 4.0.12 The following is the query iam using and the fields in the flat file are separated by character ^G. LOAD DATA INFILE /home/dbmigration/migration130_160/ttt.dat table1(one,two,three) FIELDS TERMINATED BY '^G'; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'table1(one,two,three) FIELDS TERMINATED BY '^G'' at line 1 Please look at the correct syntax of LOAD DATA INFILE: http://www.mysql.com/doc/en/LOAD_DATA.html and check your statement. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connect to mysql
Robert Morgan [EMAIL PROTECTED] wrote: Hi I have installed mysql on a linux box connected to my win2000 PC and have installed mysqlyog on win2000 pc when I try and connect through mysqlyog I get the error error no.2013 lost connection to server during query any help appreciated. What version of MySQL server? What exactly Linux do you use? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to handle Date related types in Java?
Dear All, Any body know how to handle DATE related types in Java. It seems JDBC driver fails to construct java.sql.TimeStamp object or java.sql.Date object. Thanks in Advance. Best Regards, Srinivas. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 5/27/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB backup - the best way.
Hi, I have MySQL 4.0.12 working on Debian Linux box. DB server uses MYISAM and InnoDB tables. MySQL docs shows what is the best way to backup InnoDB tables but I don't want to shutdown db server every backup time. I suppose it is not a good idea to just copy database files and innodb log files to the safe place because of unwanted rollbacks danger. What if I use mysqldump to backup databases data, and then I copy innodb log files to the safe place? I suppose I should flush tables first. I'm interested in your opinions. I'm sure that there is anybody more experienced in this matter. Regards, -- Jarek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB backup - the best way.
Dnia Wed, 28 May 2003 12:57:59 +0200 Jarek Jarzebowski [EMAIL PROTECTED] zezna/a co nastpuje: Hi, I have MySQL 4.0.12 working on Debian Linux box. DB server uses MYISAM and InnoDB tables. MySQL docs shows what is the best way to backup InnoDB tables but I don't want to shutdown db server every backup time. I suppose it is not a good idea to just copy database files and innodb log files to the safe place because of unwanted rollbacks danger. What if I use mysqldump to backup databases data, and then I copy innodb log files to the safe place? I suppose I should flush tables first. You can mysqldump InnoDB tables too. Copying InnoDB files (data or redologs) without shuting down mysql is a bad idea. You can also use mysql replication if you have spare server and do a cold backup from it. -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215770 _/ _/ _/ ==* http://szukaj.wp.pl *==-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Select name, email where birthday = ??
Hello, I have a date field in my database Format is -MM-DD Once a day at 12:01AM a script is going to run that will Select name, email from users where birthday = ?? And the ?? Is where I am stuck, I don¹t care about the year at all, I just need to match on the month and day, how would I do this? - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. You can rewrite the query the following way: Select name, email from users where substring (birthday from 6 FOR 5 )= ??; 6 is the position where it starts from, 5 is the length. _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld process hanging
I saw in my log file and I get an error as below Number of processes running now: 1 mysqld process hanging, pid 9444 - killed 030528 20:21:21 mysqld restarted /usr/libexec/mysqld: ready for connections and there is a lot of error message like that. what happen and how to solve that.? thanks in advance _ Using a handphone prepaid card? Reload your credit online! http://www.msn.com.my/reloadredir/default.asp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[My Solution] Re: Mailing Labels from MySQL database on web
Thanks for all the ideas. Here is a list of the basic paths suggested along with the comments given for each method. Nobody claimed any of these was really good and hoped someone would suggest a better approach. 1. Use MS Word's mail merge and MS Query with MyODBC as the data source. - Only good for Windows MacOSX and requires fairly high end user knowledge to download and install MyODBC and set up MS Query. 2. Use PHP to generate VBScript to control MS Word. - Difficult to set up. 3. Use PHP to build a PDF on the server in the proper Avery label format. - Nobody suggested a PDF file builder for PHP, but suggested there were cgi-scripts available for this purpose. 4. Use one of the reporting packages which can be found at sites like freshmeat.net or sourceforge.net, but nobody responding had tried this. - Nobody suggested a particular package or stated how well this might work. 5. Use PHP to create the CSV file and present it as an HTTP right-click download link on the web page. - This might be a good solution which could work with most any word processor. 6. Use PHP to dynamically produce an HTML page formatted to work with your labels and print it right from there. - Dependent upon which browser and printer is being used, i.e. not very device independent. Number 1 5 seemed like the best of what was suggested for my purposes. I decided to take path #1 and it seems to work pretty well. I've written up instructions for the end user to follow and will give it a try as soon as I get MySQL permissions straightened out. It turns out my ISP sets up only an admin user for the MySQL database on our site and this user does not have GRANT privileges. Mailing label printing works fine when MyODBC is set up using the admin account. I have a Support Ticket in with my ISP to create a couple of users with only the necessary privileges. Once this happens, I will pass it on the the Club Secretary and see if this is really a workable solution. -Landy - Original Message - From: Landy Atkinson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 2:25 PM Subject: Mailing Labels from MySQL database on web I have a club roster database set up on our web site in which the underlying data is in a MySQL database. I am using PHP to access the data and display it on a web page as a phone list, e-mail list, directory etc. Now what I need is to give the club secretary a way to print mailing labels. What is the best way to approach this? As a temporary measure, I used an auxiliary program (MySQL-Front running on a Windows PC) to create a CSV file which I e-mailed to the secretary along with instructions on how to use the file in mail merge document in MS Word to create labels. I thought about writing PHP code to create a CSV formatted output on a web page which the secretary could copy and paste into a document for the mail merge, but it seems there should be a better way. Any suggestions? -Landy -- MySQL General Mailing List 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]
