MySQL Database Forum

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...

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

--=_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...

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...

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?

--=_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...

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...

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

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

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...

Hi, I have a database with 5 teams and each team has 'n' categories and each category has 5 sub-categories. i.e TeamOne = Ottawa, Category 1 = Player Name, Sub-Categories = Goals, assists, ppg, gwg, points. Team0ne Category 1

I have a database, about 12 fields per record and roughly 100,000 records per month. I would do the following query: select count(*), type from TABLENAME where field0='23-23-23' group by type; the query would run an average of about 2secs. Not bad until I am running the same query about 1400 times all with slightly different field0...

Hi, I have a database with 5 teams and each team has 'n' categories and each category has 5 sub-categories. i.e TeamOne = Ottawa, Category 1 = Player Name, Sub-Categories = Goals, assists, ppg, gwg, points. Team0ne Category 1

I have a database, about 12 fields per record and roughly 100,000 records per month. I would do the following query: select count(*), type from TABLENAME where field0='23-23-23' group by type; the query would run an average of about 2secs. Not bad until I am running the same query about 1400 times all with slightly different field0...

HI all, I want to ask whether I can do replication in the following case. innodb (master) --replication --> myisam (slave) Rgds, Ringo --

HI all, I want to ask whether I can do replication in the following case. innodb (master) --replication --> myisam (slave) Rgds, Ringo --

Hi. With MySQL 4.1.0 alpha when I try to set default character set to tis620 MySQL start OK but have crash every time when perform to tun query (with default_character_set=latin1 it never got error) and with MySQL 4.0.14 it can do with out any error. With MySQL 4.1.0 alpha what GUI to use for connect to MySQL server with out error (due...

I know this is the mysql mailing list but I have tried the Fuse mailing list and no one will help well what im wanting to know is how could I get more avatars show in a room like I already have it where all users that are logged in control this 1 avatar im trying to make it where every user has his/her own avatar ...

Hi. With MySQL 4.1.0 alpha when I try to set default character set to tis620 MySQL start OK but have crash every time when perform to tun query (with default_character_set=latin1 it never got error) and with MySQL 4.0.14 it can do with out any error. With MySQL 4.1.0 alpha what GUI to use for connect to MySQL server with out error (due...

hi guys... i am doing the eclipse-tomcat-jboss-mysql integration but i just cant get to see why jboss wont start properly; hes a snippet of the error i am getting: Starting deployment of package: file:/C:/jboss/server/default/deploy/mysql-service.xml 15:14:32,078 WARN Duplicate throwable nesting of same base type: class...

I know this is the mysql mailing list but I have tried the Fuse mailing list and no one will help well what im wanting to know is how could I get more avatars show in a room like I already have it where all users that are logged in control this 1 avatar im trying to make it where every user has his/her own avatar ...

hi guys... i am doing the eclipse-tomcat-jboss-mysql integration but i just cant get to see why jboss wont start properly; hes a snippet of the error i am getting: Starting deployment of package: file:/C:/jboss/server/default/deploy/mysql-service.xml 15:14:32,078 WARN Duplicate throwable nesting of same base type: class...