ibdata1 lost

Hi, Is there a way to recover data and/or database schema when ibdata1 file has been removed (for InnoDB databases) ? (MySQL 5.0.26) Thanks -- Sébastien Moretti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

innodb_file_per_table cost

Hi, Does the use of innodb_file_per_table option imply a performance cost ? Compared to default: all InnoDB indexes are in ibdataX file(s). Thanks -- Sébastien Moretti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: mysql error 2013 Lost connection to MySQL server during query

Per Jessen wrote: I have just discovered that my mysql server was restarted this morning, which is what gave me the 2013. In the log I found this: [snip] It happened agaIn this morning, but slightly different: [snip] thd=0x7fe0140c7e00 Attempting backtrace. You can use the following

Re: ibdata1 lost

* Undelete the file * Restore from backup * Apply the infinite monkey theorem On Wed, May 27, 2009 at 8:41 AM, Sebastien MORETTI sebastien.more...@unil.ch wrote: Hi, Is there a way to recover data and/or database schema when ibdata1 file has been removed (for InnoDB databases) ? (MySQL

RE: ibdata1 lost

Hi, Your data is gone (unless you can undelete it from whatever filesystems you're using). You should be able to recover the schema from the directories and .frm files by doing something like this hack: 1. Take a copy of your .frm files and keep them somewhere safe. 2. Create a database with

Re: ibdata1 lost

Hi, Your data is gone (unless you can undelete it from whatever filesystems you're using). I think it's too late for this, because the MySQL server has been restarted. You should be able to recover the schema from the directories and .frm files by doing something like this hack: 1. Take a

Re: ibdata1 lost

Sebastien, On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI sebastien.more...@unil.ch wrote: Hi, Your data is gone (unless you can undelete it from whatever filesystems you're using). I think it's too late for this, because the MySQL server has been restarted. You may be able to

Re: ibdata1 lost

Sebastien, On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI sebastien.more...@unil.ch wrote: Hi, Your data is gone (unless you can undelete it from whatever filesystems you're using). I think it's too late for this, because the MySQL server has been restarted. You may be able to recover

Re: ibdata1 lost

Sebastien, On Wed, May 27, 2009 at 11:35 AM, Sebastien MORETTI sebastien.more...@unil.ch wrote: I think it's too late for this, because the MySQL server has been restarted. You may be able to recover from the file system. So long as you haven't written lots of data to the file system since

Re: ibdata1 lost

Sebastien, On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI sebastien.more...@unil.ch wrote: Hi, Your data is gone (unless you can undelete it from whatever filesystems you're using). I think it's too late for this, because the MySQL server has been restarted. You may be able to recover

Should I be able to DELETE FROM ... WHERE .. IN ( ... ) with multiple a column key?

This is in 5.0.68 and 5.1.34. I'm trying to cleanup some old data in a table which looks like the following: CREATE TABLE `transaction_history` ( `customer_id` int(10) unsigned NOT NULL default '0', `transaction_id` int(10) unsigned NOT NULL default '0', `first_timestamp` datetime NOT NULL

Re: Should I be able to DELETE FROM ... WHERE .. IN ( ... ) with multiple a column key?

On Wed, May 27, 2009 at 6:43 AM, Simon J Mudd sjm...@pobox.com wrote: So is the format of the DELETE FROM .. WHERE ... IN ( ... )  clause I propose valid and SHOULD the optimiser recognise this and be expected to just find the 2 rows by searching on the primary key? Not according to the docs:

contributing to mysql ..

hi all am new to opensource. iam a finalist student doing computer science in East Africa. i would like to start contributing to the mysql project. can u guys give me some getting started tips or hacks... anything that can help me dive in straight.. thanx Mugisha Moses -- skype name : mossplix

Re: contributing to mysql ..

here you are: http://forge.mysql.com/wiki/Contributing Greetings, Mattia Merzi. 2009/5/27 mugisha moses mossp...@gmail.com: hi all am new to opensource. iam a finalist student doing computer science in East Africa. i would like to start contributing to the mysql project. can u guys give me

Logging SQL queries

Hi, We've developed a new extranet system and feel that we need to record all queries performed. What is the best / recommended way to achieve this. Thanks Neil

RE: Logging SQL queries

Neil, You can turn on the general query log by adding a line like this to your configuration file: log=/var/log/mysql_queries.log Regards, Nathan -Original Message- From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] Sent: Wednesday, May 27, 2009 9:13 AM To: [MySQL] Subject:

Re: Logging SQL queries

Hi, you can start mysql server with --log=/someplace/my_queries.txt and every query the server runs is logged in that file. Keep in mind that if the server runs another systems all queries are logged so you need to identify the ones belong to your system. Also, if you system has a lot of query

Re: GRANT and ticks or no ticks...

2009/5/27 Daevid Vincent dae...@daevid.com Wondering which of these will work or not? (no quotes) GRANT ALL PRIVILEGES ON mydb.mytable TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD 'secret'; (backticks) GRANT ALL PRIVILEGES ON `mydb`.`mytable` TO 'user'@'10.10.10.%' IDENTIFIED BY

Create function ignore deps

I want to check all my functions and procs into my svn as individual sql files. When I use these to create my db, the person doing this may not realize the correct order to run these files and not have dependency challenges... How can I have procs that depend on functions, or vice versa, get

RE: contributing to mysql ..

mysql docs could use a translation to Swahili (if you speak/read and write Swahili) ? thanks! Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der

Re: Logging SQL queries

Enable mysql SQL logging in the configuration file. [mysqld] log Cheers Claudio 2009/5/27 Tompkins Neil neil.tompk...@googlemail.com Hi, We've developed a new extranet system and feel that we need to record all queries performed. What is the best / recommended way to achieve this.

Re: innodb_file_per_table cost

Hi Sebastian, It depends. In general, no. In some filesystems and operating systems, it actually helps. I think you can base your decision on whether it makes server administration easier for you. Regards Baron On Wed, May 27, 2009 at 2:45 AM, Sebastien MORETTI sebastien.more...@unil.ch

Re: Should I be able to DELETE FROM ... WHERE .. IN ( ... ) with multiple a column key?

per...@elem.com (Perrin Harkins) writes: On Wed, May 27, 2009 at 6:43 AM, Simon J Mudd sjm...@pobox.com wrote: So is the format of the DELETE FROM .. WHERE ... IN ( ... )  clause I propose valid and SHOULD the optimiser recognise this and be expected to just find the 2 rows by searching on

Re: Logging SQL queries

Neil, What is the purpose? Is it for auditing, performance analysis, ...? Regards Baron On Wed, May 27, 2009 at 10:12 AM, Tompkins Neil neil.tompk...@googlemail.com wrote: Hi, We've developed a new extranet system and feel that we need to record all queries performed.  What is the best /

Re: Create function ignore deps

On Wed, May 27, 2009 at 11:24 AM, Cantwell, Bryan bcantw...@firescope.com wrote: I want to check all my functions and procs into my svn as individual sql files. When I use these to create my db, the person doing this may not realize the correct order to run these files and not have dependency

Can a MyISAM DB hold /everything/?

Hi folks -- I am new to MySQL and just laying out what I hope will be just one db that holds all the info for a list of forged or machined metal parts. Let's say there are 10,000 such parts, each with a unique part number. That part number is the primary index. Each part has at least one,

Re: Should I be able to DELETE FROM ... WHERE .. IN ( ... ) with multiple a column key?

Simon, On Wed, May 27, 2009 at 11:23 AM, Simon J Mudd sjm...@pobox.com wrote: per...@elem.com (Perrin Harkins) writes: On Wed, May 27, 2009 at 6:43 AM, Simon J Mudd sjm...@pobox.com wrote: So is the format of the DELETE FROM .. WHERE ... IN ( ... )  clause I propose valid and SHOULD the

Re: Can a MyISAM DB hold /everything/?

Most commonly, you would store all information (including descriptions in teh database. The amount of data you describe is peanuts for MySQL. Then, you would probably store a path to an image in the database as well. You could then store the images on disk outside the database, or even think about

Re: Can a MyISAM DB hold /everything/?

Unless you have very good reason to store binary data like an image in your database, do not. It may work well for a time, but always be prepared that your system will grow. If it grows a good deal relative to your hardware, and users, and connections etc, you will always be in a race to

Re: Can a MyISAM DB hold /everything/?

I second that emotion (don't store the images in the data file: just store the paths to said images). Why? Because in the event of an updated image it is more hassle than it is worth, to drop the old image and replace it with the new one; if what you store is a simple pointer to an image file,

MySQL Community Server 5.0.82 has been released

Dear MySQL users, MySQL Community Server 5.0.82, a new version of the popular Open Source Database Management System, has been released. This and future releases in the MySQL Community Server 5.0 series share version numbers with their MySQL Enterprise Server counterparts. The release is now

Re: Can a MyISAM DB hold /everything/?

what if you had no issues of scaling, which would have less access time, file system or database? On Thu, May 28, 2009 at 1:54 AM, Arthur Fuller fuller.art...@gmail.com wrote: I second that emotion (don't store the images in the data file: just store the paths to said images). Why? Because in