|
> | innodb_thread_sleep_delay | 1 |
> +-++
> 36 rows in set (0.00 sec)
>
>
>
> ________
> From: Johan De Meersman
> To: Sydney Puente
> Cc: a.sm...@ukgrid.net;
nte
Cc: a.sm...@ukgrid.net; mysql@lists.mysql.com
Sent: Wed, 26 May, 2010 12:58:07
Subject: Re: source backup.sql - troubleshoot
A-ha ! :-)
That's an InnoDB table, allright. Can you check if your InnoDB file is set to
autoextend ? It smells like it's full and waiting for more space or somethin
YS */;
> I think it is this causing problems
> INSERT INTO `ping` VALUES
> ('Test1',1258368123,1,0),('Test1',1258368134,1,0),('Test1',1258368144,0,0),('Test1',1258368158,4,0),('Test1',1258368169,1,0)...
> ...
>
> TIA
>
> Syd
>
,0),('Test1',1258368158,4,0),('Test1',1258368169,1,0)...
...
TIA
Syd
From: Johan De Meersman
To: Sydney Puente
Cc: a.sm...@ukgrid.net; mysql@lists.mysql.com
Sent: Wed, 26 May, 2010 11:35:22
Subject: Re: source backup.sql - troubleshoot
The "use event" statement
On 26/05/2010 12.18, Sydney Puente wrote:
[...]
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `event` /*!40100 DEFAULT CHARACTER SET
latin1 */;
USE `event`;
Can I have the commands being issued echo to the screen somehow, so I can
identify which command is causing the problem?
Or investigate
sec)
>
> Database changed
> Query OK, 0 rows affected (0.20 sec)
>
> Query OK, 0 rows affected (0.12 sec)
>
> Query OK, 0 rows affected (0.00 sec)
>
> Query OK, 0 rows affected (0.00 sec)
>
>
>
>
>
>
> From: Johan De Meersman
: Johan De Meersman
To: a.sm...@ukgrid.net
Cc: Sydney Puente ; mysql@lists.mysql.com
Sent: Wed, 26 May, 2010 10:15:47
Subject: Re: source backup.sql - troubleshoot
On Wed, May 26, 2010 at 10:54 AM, wrote:
>
>Actually Im assuming a DB name of "source", which I mentioned in
On Wed, May 26, 2010 at 10:54 AM, wrote:
>
> Actually Im assuming a DB name of "source", which I mentioned in my first
> post. Thats actually an bad assumption as, as Ive just read, source is an
> alternative way to read in data from a file that Id never seen before.
> However the syntax would st
Quoting Johan De Meersman :
On Wed, May 26, 2010 at 10:20 AM, wrote:
If you are trying to restore from backup.sql to a database called soure
then your syntax is wrong. You should be running:
mysql source < backup.sql
You are assuming that the file named "backup.sql" contains a backup of t
On Wed, May 26, 2010 at 10:20 AM, wrote:
> If you are trying to restore from backup.sql to a database called soure
> then your syntax is wrong. You should be running:
>
> mysql source < backup.sql
>
You are assuming that the file named "backup.sql" contains a backup of the
database named "backup
Quoting Sydney Puente :
Hello,
I have a mysqldump file created by AutoMySQLBackup.
And it hangs when I do a
mysql > source backup.sql
If you are trying to restore from backup.sql to a database called
soure then your syntax is wrong. You should be running:
mysql source < backup.sql
Assumi
On Tue, May 25, 2010 at 2:39 PM, Sydney Puente wrote:
> Hello,
>
> I have a mysqldump file created by AutoMySQLBackup.
> And it hangs when I do a
> mysql > source backup.sql
> It is 32 MB - it creates 4 tables and after creation of each table it
> populates it.
> Actually it only creates the 1st
2:39 PM
> To: mysql@lists.mysql.com
> Subject: source backup.sql - troubleshoot
>
> Hello,
>
> I have a mysqldump file created by AutoMySQLBackup.
> And it hangs when I do a
> mysql > source backup.sql
> It is 32 MB - it creates 4 tables and after creation of each
&g
Hello,
I have a mysqldump file created by AutoMySQLBackup.
And it hangs when I do a
mysql > source backup.sql
It is 32 MB - it creates 4 tables and after creation of each table it populates
it.
Actually it only creates the 1st table before hanging.
My first thought is it would be nice to echo e
14 matches
Mail list logo
