MySQL Database Forum

Experts, Given a script that uses the following format to create tables on the fly: CREATE TABLE $tName ( id int(11) unsigned NOT NULL auto_increment PRIMARY KEY, p_MSG text,

Hello, I've tried resolving this issue in a SuSE newsgroup, but after trying their suggestions and working on this issue for far too long already, I decided to try this list as it may be a more appropriate discussion area. I've installed and configured MySQL 4.0.18 on a SuSE 9.1 system using the default RPM's that came with the...

I am using MS Access as a front end to a MySQL server on a windows platform. The problem is that when I add a new record to a list (continuous form) of records as soon as the cursor moves to another record the just entered data appears as #DELETED until I requery the form. The problem is that the record does not appear to get an ID until it is...

I have 5500 names to insert into a table. what is the best way - without having to type all 5500 records... Help Please email me diect

Hey folks - Is there an easy way to find child tables for any given table in MySQL 4.1? Right now, I'm running SHOW CREATE TABLE `$table` for all tables, and then seeing if they have the table I'm looking for any foreign key relationship. There has got to be a better way, right?

Plz help, I have the following query which runs fine without the insert statment. INSERT INTO `db_x`.`attributes` (id, typeid, value, start_time, end_time) SELECT distinct i.id, at.id AS typeid, d.megapixels AS value,

How do I enable MySQL to accept ssl connections using the rpm version of MySQL 4.1.10. I am using RHEL 3.0. Can some one point in the right direction? Thanks in advance, Matias

My MySql experience is limited to simple updates and selects. I am creating a genealogical site based on Old Church birth and christening records. Currently I have over 70,000 entries in the database and I want to link the parents together in order to see all their children. Currently I have the following fields FatherGiven, FatherLastName,...

HI to All.... i need an help for a Select Query MYSQL Version 3.23.58 it's all day i try to resolve this problem.... but i don't find SOLUTION! sigh :-( This is the simple query.....

Hi, I have read up on MySQL failover/replication and decided that weren't many cons to setting up two way replication where two servers are both master and slave to eachother. Here's the my.cnf: log-bin log-slave-updates server-id=2 master-host=10.0.0.2 master-user=repl

Now let me describe what I have done and my purpose: Originally, I want to user ports to install phpBB But I found that phpBB doesn't support mysql 5.x (but the ports installed mySQL 5.0.0 alpha) so I deinstall mysql5-server and mysql5-client And then I install mysql41-server and mysql41-client on FreeBSD 5.3 by ports but now , mysql is...

Hi I'm trying to replicate a database to a server. from the server I try : mysqldump -h remote_host --opt --compress eslsl -u dbmaster -p \ mysql eslsl Enter password: mysqldump: Got error: 2003: Can't connect to MySQL server on 'remote_host' (60) when trying to connect I'm sure from the remote host name / ip but still can't connect...

I just installed mysql on linux. If I open a terminal, su to root, then type "mysql", I am able to connect to the server and run my queries. If I exit out of su so that I am my own id (baisley) and type "mysql", I get this error: Can't connect to local MySQL server through socket '/home/data/mysql/mysql.sock' (13) Any idea why?...

Hi All I've tried and tried, but I can't seem to find the version history section for their MySQL Administrator program. I've just downloaded v1.0.19, but have no idea what is in this that isn't in v1.0.18.

I have a MySQL-server running Innodb. We have installed ~ 2GB of memory in the server. In spite of this MySQL keeps crashing due to out-of-memory errors. The server is a dual xeon i686 running kernel Linux 2.4.20-8smp redhat stock. Top shows mysql steadily consuming more resourses over a period of 2 hours, up to 1.2 Gb, before it...

I'm a newbie to MySQL and am really confused about when I should be using the Command Line Client and when the DOS prompt. I'm using Windows XP and I've just installed MySQL 4.1.10. I can use the Command Line Client to logon as 'root'. It prompts me for a password and then I can create databases, etc. from the mysql prompt. However, if I...

mysql> select * from guestbook; +----+--------+---------+-----------------+----------------+ | id | fname | lname | comments | time_in | +----+--------+---------+-----------------+----------------+ | 1 | Mick | White | Test 123 | 20050303191815 | | 2 | Ann | White | Hello World | 20050303191931 | | 3 |...

Folk, I have mysql installed via rpm package, but when I check the data dirs, the only table there is "test". The instructions say there should be others, like users tables, and other such tables. I stopped the server and ran mysql_install_db which is the command to create these, I get the following excerpt: linux:/usr/bin #...

Hi everyone, Machine info: Fedora Core 3, MySQL-server-4.1.9, and perl-DBD-MySQL-2.9003-5 When I try to use mysqlhotcopy command to backup database, following error occurs :(& install_driver(mysql) failed: DBD::mysql object version 2.9003 does not match bootstrap parameter 2.0419 at

----02-82381-3597-055-04659 Content-Type: text/plain; Content-Transfer-Encoding: quoted-printable Get a FREE PlayStation 2 or PlayStation Portable! You decide! It's your choice! Think I'm kidding? Check the link below: http://www.c-u-i.com/offer.php?45PV69

Anybody know when the new version of the ODBC Driver is gonna be out? I'm using 3.51.11-1, but I'm having problems transferring information from SQL Server. Thanks.

Hi guys, which query should I do to get it? thx to all, chr

Hello, Here is my table layout: > describe samples; | user | varchar(64) | | PRI | | host | varchar(255) | | PRI | | command | blob | | | | date | datetime | | PRI | | pid | int(11) | | PRI | | jval | smallint(6) | | |

I have MySQL 4.1.10 running successfully on an office XP machine, but when I try to set up similar XP box at home I continually get this error: "Error 2013: Lost connection to MySQL server during query". The install went fine, and Windows XP is recognizing it as a running service. But whenever I try to connect via one of my GUI applications...

Hello, Have small job for next weekend. Need to migrate 8 GB mysql 3.x from sol 8 netra T1 to 4.1 on sol 9 sunfire 210. No X available for whizzy GUI. Is there an obvious approach to doing this? And caveats or gotchas? Any fine manuals I shoul dread beforehand? TIA