Re: GUI (linux X based or web based) for mysql

Hello, Dotan Cohen schrieb: I keep a lot of personal information in a MySQL database. I have a few querys premade for the wife to use, but we have gotten to the point where we need a solution for her to be able to run her own queries. She is NOT about to learn SQL, and myPHPadmin is a little

Re: rentering a sql script

Jon Miller wrote: I have a sql script that needs to be re entered using the following command mysql create.sql but the database already exists. IS there a way to overwrite or update the database using the script, or do I have to delete the existing database?

Re: Table Lock issue on insert

Hi John, What kind of engine are you using on your table? MyIsam or InnoDB or are you using merged tables? If you query your system variables what is your max_write_lock_count? If you create a copy of the table: mysqlcreate table cp1 like USERS_PER_HOUR; and you try the insert again; is the

Understanding Unicode

Hi, I have db users from all over the world. I only understand english. This is rarely a problem since I almost never need to look at users data, but every once in a while I do need to, usually this is while reviewing logfiles. Here is an example. Selecting a text field from a table I

I can't find the missing rows in a table--

This should be so simple, yet I've struck out. I have 2 tables, each with a common column called pid which is an integer and is a unique index. There are approx 18 million rows in each table, and one of the tables has approx 5000 fewer rows than the other table. So it should be a piece of

Row Count Discrepency

I have an InnoDB table in a MySQL 4.1.14 database. Can anyone suggest why MySQL Adminstrator says the table has 497 rows, while doing a query or a count on the same table shows that it only has 434? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

cannot connect to database

I'm trying to initialize to a database on another server from a mail server. I can telnet to it but cannot initialize the database. The account and user exists in the database and the paasword as I've tried it from the mysql server. Is there another test I can do to find out exactly what is

testing for connectivity to database

I'm trying to initialize to a database on another server from a mail server. I can telnet to it but cannot initialize the database. The account and user exists in the database and the paasword as I've tried it from the mysql server. Is there another test I can do to find out exactly what is

Re: cannot connect to database

add a user in the table for your remote hostname or ip number. On 12/31/05, Jon Miller [EMAIL PROTECTED] wrote: I'm trying to initialize to a database on another server from a mail server. I can telnet to it but cannot initialize the database. The account and user exists in the database and

Re: I can't find the missing rows in a table--

mos a écrit : This should be so simple, yet I've struck out. I have 2 tables, each with a common column called pid which is an integer and is a unique index. There are approx 18 million rows in each table, and one of the tables has approx 5000 fewer rows than the other table. So it should

MySQL 4.1.13 and utf-8 language encoding

Hello list: I have a php website which uses utf-8 encoding. But recently the shared hosting company has upgraded mySQL to 4.1.13 and now all varchars are shown incorrectly ( all collation attribute are set as latin_swidish_ci now ).. the phpMyAdmin verson is 2.6.4-pl2. my site is at