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 too compicated. I looked at an Access installation the other day and it seemed to be just what we need- a GUI for non-programmers to use a database. Is there any such beast for MySQL? Anthing that will run on Fedora Core 4 would be great. Or even a web-based solution would be fine- I do have apache on localhost. You can use OpenOffice.org 2.0 via ODBC or JDBC and you can use a GUI nearly like Access under Linux. Mechtilde -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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? !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 6.00.2900.2802 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVI have a sql script that needs to be re entered using the following command mysql lt; create.sql but the database already exists.nbsp; IS there a way to overwrite or update the database using the script, or do I have to delete the existing database?/DIV DIVnbsp;/DIV DIVnbsp;/DIV/BODY/HTML Hi Jon, You will have to drop the database first if you wish to start from scratch. If you wish to update the records, the syntax at http://dev.mysql.com/doc/refman/5.0/en/create-database.html would be useful, 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: 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 error gone? Danny Brittingham, John wrote: I am having trouble with table lock. The query is as follows: INSERT INTO USERS_PER_HOUR SELECT count( DISTINCT ( CUID ) ),`TV_LOG_DATE`,`TV_LOG_TIME`, INTERFACE_ID FROM `TV_LOG_ALL` group by 2,3; I keep getting this error: #1206 - The total number of locks exceeds the lock table size How do I fix this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 get the string (truncated): aHR0cC8xLjAgMjAwIG9rDQpzZXJ2ZXI6IDB3LzAuNmQNCmRhdGU6IHRc3 My wild guess is that this is a unicode string. Is there any way for me to work with this raw data and display the text in it's native character set? Thanks, Gary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 cake finding the missing rows right? Well I did a select * from t1 left join t2 on t1.pid=t2.pid where t2.pid is null select * from t2 left join t1 on t2.pid=t1.pid where t1.pid is null and both queries return a null set. I then checked both tables and none of them have pid as null. I then counted the number of non-unique pid's and there aren't any (of course with a unique index I didn't think there would be) Ok, so there are no rows in t1 that aren't in t2, and vice versa. There are no duplicate sid values and no empty sid values. I physically counted the rows in each table and they are indeed off by around 5000 rows. I checked the tables for consistency and they passed. How can anyone explain this? How do I find the missing rows? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 causing the problem? The firewall is set to allow port 3307 (it the port mysql listens on). Thanks !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 6.00.2900.2802 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVI'm trying to initialize to a database on another server from a mail server.nbsp; I cannbsp;telnet to it but cannot initialize the database./DIV DIVThe account and user exists in the database and the paasword as I've tried it from the mysql server./DIV DIVIs there another test I can do to find out exactly what is causing the problem?nbsp; The firewall is set to allow port 3307 (it the port mysql listens on)./DIV DIVnbsp;/DIV DIVThanks/DIV DIVnbsp;/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 causing the problem? The firewall is set to allow port 3307 (it the port mysql listens on). Thanks !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 6.00.2900.2802 name=GENERATOR/HEAD BODY style=MARGIN-TOP: 2px; FONT: 10pt Arial; MARGIN-LEFT: 2px DIVI'm trying to initialize to a database on another server from a mail server.nbsp; I cannbsp;telnet to it but cannot initialize the database./DIV DIVThe account and user exists in the database and the paasword as I've tried it from the mysql server./DIV DIVIs there another test I can do to find out exactly what is causing the problem?nbsp; The firewall is set to allow port 3307 (it the port mysql listens on)./DIV DIVnbsp;/DIV DIVThanks/DIV/BODY/HTML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 the paasword as I've tried it from the mysql server. Is there another test I can do to find out exactly what is causing the problem? The firewall is set to allow port 3307 (it the port mysql listens on). Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Anthony Ettinger Signature: http://chovy.dyndns.org/hcard.html
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 be a piece of cake finding the missing rows right? Well I did a select * from t1 left join t2 on t1.pid=t2.pid where t2.pid is null select * from t2 left join t1 on t2.pid=t1.pid where t1.pid is null and both queries return a null set. I then checked both tables and none of them have pid as null. I then counted the number of non-unique pid's and there aren't any (of course with a unique index I didn't think there would be) Ok, so there are no rows in t1 that aren't in t2, and vice versa. There are no duplicate sid values and no empty sid values. I physically counted the rows in each table and they are indeed off by around 5000 rows. I checked the tables for consistency and they passed. How can anyone explain this? How do I find the missing rows? TIA Mike The 2 queries you paste seemed correct and should output the result unless there is something really strange happening. If you are using a version that support subquery you could try select * from t1 where id not in (select id from t2); Not sure which exactly is suppose to be faster but it's worth a try! Is it possible that you are hitting some kind of limit on maximum join number in your server ? I'm not even sure if a limit of that kind exists (Just putting my tought on the table) -- Mathieu Bruneau aka ROunofF === GPG keys available @ http://rounoff.darktech.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 http://www.cnads.org/. Can anyone tell me how to fix this? Thanks Li __ 赶快注册雅虎超大容量免费邮箱? http://cn.mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]