MySQL Database Forum

I have 2 backup files (using mysqldump.) The first one is for the whole database, backed up from Januaray to July 25. The second one is just for 2 tables of that database, backed up from June 29 to July 29. These 2 tables are updated continuously, and from July 25 to July 29, there is no new record in the rest of the tables. The data in both...

I have 2 backup files (using mysqldump.) The first one is for the whole database, backed up from Januaray to July 25. The second one is just for 2 tables of that database, backed up from June 29 to July 29. These 2 tables are updated continuously, and from July 25 to July 29, there is no new record in the rest of the tables. The data in both...

hello, MySQL lets CURRENT_TIMESTAMP tick on inside transactions. I'm wondering why? doesn't this violate the atomicity of transactions? thank you, Lodewijk

hello, MySQL lets CURRENT_TIMESTAMP tick on inside transactions. I'm wondering why? doesn't this violate the atomicity of transactions? thank you, Lodewijk

Is there any means of running MySQL (3.23, mostly MyISAM tables running on Win2k Server) so that escaped character sequences (those preceded by a backslash \) are _not_ interpretted as anything other than literals? We're trying to port a large number of web applications that previously used MS SQL and Access to use MySQL Server and this has...

Is there any means of running MySQL (3.23, mostly MyISAM tables running on Win2k Server) so that escaped character sequences (those preceded by a backslash \) are _not_ interpretted as anything other than literals? We're trying to port a large number of web applications that previously used MS SQL and Access to use MySQL Server and this has...

--=_81DF9BED.E485C8BC Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hello gang, This may be a very simple question and possibly could have a very simple solution to it. Since I have been using mysql for less than 2 months, I still consider myself a newbie.... I still cannot execute certain commands from my...

--=_81DF9BED.E485C8BC Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hello gang, This may be a very simple question and possibly could have a very simple solution to it. Since I have been using mysql for less than 2 months, I still consider myself a newbie.... I still cannot execute certain commands from my...

I have mysql running on red hat linux 8 I have data from about a month of testing I also have mysql on windows xp with no data I want to copy the mysql from linux to XP that way they will both have the same data how do I do this?

Hello, I installed MySQL 4.0.14 on a new Linux machine unde the form of two servers: one master and one slave. I met many unsynchronized events so it was appears conflicts from this late of the changes from master to slave. I put the master-connect-retry to 2. Now it seems to work clearly but I cannot see the master-connect-retry variable...

--=_9EC08B1B.CCADE08C Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hello gang, This may be a very simple question and possibly could have a very simple solution to it. Since I have been using mysql for less than 2 months, I still consider myself a newbie.... I still cannot execute certain commands from my...

How can I make hotcopy of my database if it have many tables (more than 1000) ??? mysqlhotcopy failed when it try to lock all tables ... How many tables can I lock at one time ? Can I increase this limit ? Working system: RedHat 7.3 MySQL 3.23.56 (compiled manualy) Perl 5.6.1

Howdy List! A couple questions about finding the disk space used by a = table/database: 1) First how can I get the size a table is taking up on disk? Is it the 'Data_length' field in: SHOW TABLE STATUS FROM db_name LIKE = 'wild';?? If so how can I do a query like the one above and just get Data_length = returned? Otherwise what query can...

I have a question that I hope I can explain well enough: I am trying to figure out a data structure for an inventory system. The system contains: Items Kits (Made from a collection of Items and/or other Kits) Now my question is:

I have a question that I hope I can explain well enough: I am trying to figure out a data structure for an inventory system. The system contains: Items Kits (Made from a collection of Items and/or other Kits) Now my question is:

------_=_NextPart_001_01C3569E.29752420 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi folks =20 I need a MySQL statement that will calculate a new unique identifier for each record in a table. =20

my query: SELECT * FROM `links` WHERE MATCH ( KEYWORDS ) AGAINST ( 'paper' ); I have a table with 4 records in it of links to various newspapers, paper and newspaper are both in the keywords field. The keywords field has a fulltext index on it. Did I totally miss a step somewhere? The query doesn't error, I just get 0 results back. ...

I have a program that I am writing in PHP/MySQL. I have made some upgrades to the database and like an idiot, forgot to write down the changes or to make the changes in several other databases for the other clients that are using the program also. What I am trying to do is to have a program, (preferably in PHP) that will look at the...

--=_5D034890.F392DE43 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hello gang, This may be a very simple question and possibly could have a very simple solution to it. Since I have been using mysql for less than 2 months, I still consider myself a newbie.... I still cannot execute certain commands from my...

--=_075912CF.F899D547 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hello again all, I have created an account in the particular database that I was trying to backup Using PHPMYADMIN and I also created the same user account on the OS side. I still got the same 1064 message afterwards. I am still relatively...

Hi , I am trying to export a database from one machine ie linux, and import the same database to another machine ie ,solaris . I exported the database using the following command . mysqldump -c -u vidhya ifmonitor > $HOME/ifmonito.backup. this is ok , ifmonitor-backup has the table creation info as well as the table data .

Hi , I am trying to export a database from one machine ie linux, and import the same database to another machine ie ,solaris . I exported the database using the following command . mysqldump -c -u vidhya ifmonitor > $HOME/ifmonito.backup. this is ok , ifmonitor-backup has the table creation info as well as the table data .

$B$*@$OC$K$J$C$F$*$j$^$9!#(B $B%D%?%M%9(B@TSTI$B$G$9!#(B SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: dtutanes To: mysql@lists.mysql.com Subject:

Hi, When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb: /usr/local/mysql/data/log.0000000001: Permission

------=_NextPart_000_0065_01C35631.403B9A20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Following statement was working fine untill recently when someone = entered specail characters in insert statement. eg