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:
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:
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
* 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
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
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
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
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
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
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
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
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:
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
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
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
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:
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
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
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
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
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.
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
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
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 /
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
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,
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
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
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
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,
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
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
32 matches
Mail list logo