[First email] Problem with backup and ID's for a Database with INNODB

2012-01-25 Thread Carlos Sura
Hello, I'm new here, so since this is my first question email, I'm looking for an advice/help a way to do it or a link which can explain me more about my related question. This is the thing: Reciently I've made a backup of a database using INNODB, 1GB database, for a web based - software (IEM) s

the rest of Latin1 in a regular expression

2012-01-25 Thread Hal�sz S�ndor
This is a decent approximation to matching one "word" in an email-address, separated by dots, and, of course, the commercial multiplication sign "@" [!#-'*+/-9=?A-Z^-~-]+ but I want to add the Latin1 graphics to it. Is this best done by concatenation, '[-!#-''*+/-9=?A-Z^-~' || x'A0' || '-' || x

Re: RES: Force drop table

2012-01-25 Thread Todd Lyons
On Wed, Jan 25, 2012 at 6:42 AM, Todd Lyons wrote: > For example, I shut down my mysql daemon, I make a copy of my > corrupted database at /var/lib/mysql/ into /var/lib/mysql_tmp/, and > then manually start the mysql daemon in the foreground with this: > su - mysql -c '/usr/libexec/mysqld --innod

Re: RES: Force drop table

2012-01-25 Thread Todd Lyons
2012/1/24 Suporte Avanutri : > I've tried this before, but the server stills going down. The first error is > always this: > > Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */* FROM 'usuario': Lost > connection to MySQL server during query (2013) What's likely happening here is that the access

Re: RES: RES: Force drop table

2012-01-25 Thread Johan De Meersman
Can you send the error logs from my and Suresh' solutions, so we can see what the next thing to go wrong is ? :-) - Original Message - > From: "Suporte Avanutri" > To: "Suresh Kuna" > Cc: "Johan De Meersman" , "Shafi AHMED" > , mysql@lists.mysql.com > Sent: Wednesday, 25 January, 2012

RES: RES: Force drop table

2012-01-25 Thread Suporte Avanutri
No good news until now... I’m starting to think that I will not recover it. When all these tips doesn’t work, should I presume that my database is dead? De: Suresh Kuna [mailto:sureshkumar...@gmail.com] Enviada em: quarta-feira, 25 de janeiro de 2012 02:10 Para: Suporte Avanutri Cc: Johan

Re: Suggestions for ibdata files structure

2012-01-25 Thread Adarsh Sharma
Adarsh Sharma wrote: Thanks for the suggestions. Last thing to close this topic :- I create new partitions & files for ibdata files as :- log-bin=/hdd5-1/mysql-bin innodb_data_file_path = /hdd2-1/innodb_data1/ibdata1:250G;/hdd3-1/innodb_data2/ibdata2:250G;/hdd4-1/innodb_data3/ibdata3:8G:aut