RE: backup/restore

Hi, Thank you for your reply. If I have the create table info in my dump file, while doing the restore using mysql dbname < dump.dmp, I am getting errors like mysql -uMNMSDBA -pMNMSDBA -f mnms < c:\progra~1\mitel\opsman~1\temp\almhist.dmp ERROR 1050 at line 11: Table 'alarm' already exis

Re: use of soundex in queries

Raphael Matthias Krug wrote: Hi, I need to compare names from different tables and therefore I need to know the proper use of soundex. I googled for it, but could not find anything useful. And select soundex('text') is no help for me. FYI Soundex has real problems ... use DoubleMetaphone... Ke

Re: backup/restore

I'm a beginner - but can't you also use mysqlimport? Respectfully, Ligaya Turmelle Tom Crimmins wrote: [snip] I am doing backup for tables using Mysqldump. But while doing the restore I am not able to do that using the same Mysqldump. Could you please help me in that. [/snip] mysqldump is not inten

RE: backup/restore

[snip] I am doing backup for tables using Mysqldump. But while doing the restore I am not able to do that using the same Mysqldump. Could you please help me in that. [/snip] mysqldump is not intended to be used for the restore. You need to run the following: mysql -D dbname < mysqldumpfile You

disorder resualt order by a Chine word field

Hi, If a select order by a field cotians Chinese GB code word, The query result is disorder . A GB code Chinese word are 2 char wich acsii >=128 and <=255 . The My.ini set Latin1 , else if set to GB,the resualt shows "?" . Best Regards, Shuming Wang

RE: Update a Field in a table to Uppercase

[snip] Does anyone have a sample of a simple update statement I can run to update a field in a table to all uppercase values. [/snip] UPDATE mytable SET mycol=UPPER(mycol); --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http:/

User can't login to his DB.

Hi list, I use the following commands to create a user hubert access to his DB only, but got the following error: # perl view.pl DBI connect('datacube','hubert',...) failed: Access denied for user 'hubert'@'localhost' (using password: YES) at view.pl line 8 Unable to connect: Access denied for us

RE: Max connections being used every 10-12 day.

The inner join should ALWAYS return a faster result than the union, if you have the indexes correctly. Can you send me the explain of the inner join version and also the full table structure and indexes on the table? This should be fairly easy to solve. > -Original Message- > From: Fredr

mysql tablespace monitoring

First of all, thanks for the mailing list for giving details about myisamchk.we used them but we got some errors which I have reported in 'myisamchk errors' mail to mysql. At present we are working in mysql 3.23.32 ,windows xp os. Are there any system tables that store mysql related info.(like me

Re: Max connections being used every 10-12 day.

The inner join statement returned the same stuff but it was not as fast as the union is and the inner join seems to use more cpu resources. Could these union queries really be the problem behind my occasional lock ups and that 200 connections being used? i mean the server is not that loaded and

RE: Max connections being used every 10-12 day.

Frederick, What exactly are you trying to accomplish? Personally, I don't recommend using union unless absolutely necessary, since most people don't really understand when it should be used. And I think it shouldn't be used in this case either. Select A.id, A.parent, B.id, B.parent from art A i

Re: Master will insist on running as a SLAVE if data/master.info exists.

Kevin A. Burton wrote: Mikael Fridh wrote: Kevin A. Burton wrote: This is a bug. Feature. Putting system configuration information on a unix machine in /var.. .yeah... thats not a feature. It's a feature because you installed it there. I decided to put my datadir in /mysql/data which makes the con

backup/restore

Hi, I am doing backup for tables using Mysqldump. But while doing the restore I am not able to do that using the same Mysqldump. Could you please help me in that. For backup : using Mysqldump -databases ---tables table1 table2 > dump.dmp For restore : used Mysqldump -databases < d

ISAM to MyISAM Convert pls

hello i hope im correct here i have a problem, after upgrade 4.1 from 4.0 one table is away (index) i have table.ISM,.frm and .ISD. when i try to convert it with ALTER TABLE table TYPE = MYISAM; he only says did not found table.MYI (where table is my name of the table) how i can convert it to MYI?

Re: Max connections being used every 10-12 day.

Fredrik Carlsson wrote: It is a single PIII 500MHz, so i just changed thread_concurrency to 2 :), thanks The slow query log don't show that many slow queries, but they did show alot of queries that was'nt using any index, can these queries cause some kind of occasional lock up? Is there a fas

Re: Max connections being used every 10-12 day.

It is a single PIII 500MHz, so i just changed thread_concurrency to 2 :), thanks The slow query log don't show that many slow queries, but they did show alot of queries that was'nt using any index, can these queries cause some kind of occasional lock up? Is there a faster way to perform this

Re: is there a utility like mysqlbinlog but instead processes the query log?

On 30 Dec 2004, at 13:26, Daniel Gaddis wrote: is there a utility like mysqlbinlog but instead processes the query log? I would like to reprocess the queries from the query log. I don't see another reply to this on the list, so I hope it helps - the query log is already in plain-text, so you don'