Problems with a full backup

Hi! I'm learning mysql and I have a problem when i make a full backup with mysqldump. I have a lot of table rows written in spanish. In the backup file (.sql) I have problems with certain spanish characters like: á --> Ãi é --> é í --> Ã- ú --> ú and so many others like that. However, when I mak

Mysqldump alternative due to bug

I'm using Mysql 5.0.2 w/ Windows 2003 server, and there is a bug with the mysqldump utility. The bug is actually with the Describe table statement, or Show fields from table statement... It's been documented on mysql.com, so I'm wondering if there is a simple alternative to mysqldump that I can u

show databases;

I am on linux Fedora 2 with mysqld running as a daemon and the service mysql running (/etc/rc.d/init.d/). I have two shell sessions (mysql client) running one with root and the other with a user. I did (as root) : grant all privileges on mydb to [EMAIL PROTECTED]; in the root session the show d

MySQL/InnoDB-4.0.24 is released

Hi! InnoDB is the MySQL table type that supports FOREIGN KEY constraints, transactions, row-level locking that is never escalated, multiversioned concurrency control, asynchronous unbuffered disk I/O on Windows, and a non-free online hot backup tool. InnoDB is an 'ACID'-compliant table type. In

RE: Problem: Too many connections

Back to the original problem ;) Please post your my.cnf. -Original Message- From: Steve Buehler [mailto:[EMAIL PROTECTED] Sent: Samstag, 12. März 2005 16:02 To: mysql@lists.mysql.com Subject: Re: Problem: Too many connections At 01:25 AM 3/12/2005, sapna murari todwal wrote: >Hi, >I ha

Re: Problem: Too many connections

At 01:25 AM 3/12/2005, sapna murari todwal wrote: Hi, I have a live site using mysql. It is heavily used with over thousand users per minute, with 3 select / update queries per user per minute accounting to over 3000 queries per minute. The problem is that many times connection to this mysql se

Re: Limit of a sql script

Hi, The only limit I'm aware of is the size of a query itself, which can not be bigger than the max_allowed_packet size. Regards, Jocelyn Mauricio Pellegrini a écrit : Hi , I'm using mysql 4.1.4 gamma with InnoDB suse 8.2 reiser fs. I'am doing backups using mysqldump which creates a sql scrip

Re: INSERT ON DUPLICATE KEY UPDATE

Hi, It could perhaps be related to bug #8147. http://bugs.mysql.com/bug.php?id=8147 Regards, Jocelyn Aleksandr Guidrevitch a écrit : Hi all ! I'm having problem with INSERT ... ON DUPLICATE KEY UPDATE on mysql 4.1.10 --8<--8<--8<--8<--8<--8<--8<--8<--8< INSERT

Limit of a sql script

Hi , I'm using mysql 4.1.4 gamma with InnoDB suse 8.2 reiser fs. I'am doing backups using mysqldump which creates a sql script with the structure for all tables plus the correspondig commands to create them and also the data to be inserted in each one of them. Latter when I have to restore one o

INSERT ON DUPLICATE KEY UPDATE

Hi all ! I'm having problem with INSERT ... ON DUPLICATE KEY UPDATE on mysql 4.1.10 --8<--8<--8<--8<--8<--8<--8<--8<--8< INSERT INTO lot_end (id, owner_id, category_id, title, current_price, buy_price, end_time, price, bid_count, currency_name) SELECT lot.id, lo

Re: insert - select from two different applications race condition?

- Original Message - From: "Aragorn" <[EMAIL PROTECTED]> To: Sent: Saturday, March 12, 2005 1:47 AM Subject: insert - select from two different applications race condition? > I have a simple problem... > > I'm using mysql 4.1.9/innodb table and two small python applications A and B > >

Tables and Unicode Characters

Hi all! I've a problem with insert unicode characters on my database. I use Mysql 4.1.10 on Win and Linux-Debian and I share the same database. My server, client and database are on utf8 character, but my keyboard is on Spanish. I need introduce IPA characters on my table of a database whit or n

Tables and Unicode Characters

Hi all! I've a problem with insert unicode characters on my database. I use Mysql 4.1.10 on Win and Linux-Debian and I share the same database. My server, client and database are on utf8 character, but my keyboard is on Spanish. I need introduce IPA characters on my table of a database whit or not

RE: Hebrew

Greg I use MySQL Control centre to access my dbase and I have set My character_set_xxx variables to Hebrew I then looked at the values, show variables like '%char%'; and all was fine. However if I then exit MySQL Control centre and then go back to it my character_set_xxx variables are all back