| Author |
Message |
filegrasper
knows MySQLDumper
Joined: 20 Jun 2011
Posts: 8
|
 Posted:
2011-06-20, 20:21 mysql dump problem |
  |
i tried to import my sql.gz file using mysqldumper after importing certain records it get stopped without throwing any errors. wat shall i do??
my backup file size is 800mb in gz format
and databse size is 5.2gb
and i like to omit certain table while importing .i found the option available but it shows this is not supported for this format. how can i do that??
|
|
    |
|
Anzeigen
|
|
Posted:
Anzeigen |
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16073
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-06-20, 20:39 Re: mysql dump problem |
|
« filegrasper » wrote: i tried to import my sql.gz file using mysqldumper after importing certain records it get stopped without throwing any errors. wat shall i do??
With a packed 800MB file it takes too long to place the file pointer at the correct position after each page refresh. The more the file is processed, the longer it takes.
It can (and maybe will) happen that this process times out. There is nothing we can do because this happens before MySQLDumper even gets a single Byte of the backup.
That's why we always recommend to use Mulipart for bigger data files.
Quote: and i like to omit certain table while importing .i found the option available but it shows this is not supported for this format. how can i do that??
This option can only be used if the backup was created using MySQLDumper.
So what can you do?
You could import your backup into a locally installed web server like Xampp or Zend Server. There you have control over limits and timeouts and can configure your local server in a way it works.
Afterwards you could do a new export using MySQLDumper. While you are here you could only export those tables you want to import on your online server. But this time use the option "Multipart" and use a split size of 50MB parts. Don't worry, MySQLDumper will detect that this is a Multipart-Backup and will load all part files automatically. You only have to upload them into the folder work/backup. 
Another try would be to use the converter. It splits the file automatically in 50MB parts. But the converter can't bypass the max_execution_time and so this will possibly lead to a timeout too.
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
 |
|
filegrasper
knows MySQLDumper
Joined: 20 Jun 2011
Posts: 8
|
|
Posted:
2011-06-20, 20:48 can u help me in this?? |
|
i can say the location wer my backup file can be downloaded amg can u convert that backup into mysqldumper backup?? so that i can restore ceratin tableS??
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16073
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-06-20, 20:51 (No subject) |
|
Of course I could. Will you donate some buckets in return?
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
| |
|
filegrasper
knows MySQLDumper
Joined: 20 Jun 2011
Posts: 8
|
|
Posted:
2011-06-20, 20:59 (No subject) |
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16073
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-06-20, 21:01 (No subject) |
|
Deal.
Send me the download link via pn or via email to admin at mysqldumper dot de.
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
| |
|
filegrasper
knows MySQLDumper
Joined: 20 Jun 2011
Posts: 8
|
|
Posted:
2011-06-20, 21:05 (No subject) |
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16073
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-06-20, 21:55 (No subject) |
|
« DSB » wrote: Will you donate some buckets in return?
My English is funny.
Please replace "buckets" with "bucks". 
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
| |
|
filegrasper
knows MySQLDumper
Joined: 20 Jun 2011
Posts: 8
|
|
Posted:
2011-06-20, 21:59 (No subject) |
|
« DSB » wrote: Please replace "buckets" with "bucks".
i can understand bunny english like this 
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16073
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-06-20, 22:05 (No subject) |
|
As a coder it's enough to understand the english PHP function names and the documentation.
I code better than I speak.
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
| |
|
filegrasper
knows MySQLDumper
Joined: 20 Jun 2011
Posts: 8
|
|
Posted:
2011-06-20, 22:10 (No subject) |
|
« DSB » wrote: I code better than I speak
i know that u code better becoz u had developed this mysqldumper script which is better,best than all
as i know that u are the best coder am asking help to u
_________________
World's Best Sharing Forum
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16073
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-06-20, 22:26 (No subject) |
|
Thanks.
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
| |
|
Kyoya
Developer
Age: 29
Joined: 22 Sep 2010
Posts: 74
|
|
Posted:
2011-06-20, 22:40 (No subject) |
|
« DSB » wrote: As a coder it's enough to understand the english PHP function names and the documentation.
I code better than I speak.
Or with other words:
(We) Speak German, English or PHP.
_________________
You can't stop me.
|
|
  |
|
filegrasper
knows MySQLDumper
Joined: 20 Jun 2011
Posts: 8
|
|
Posted:
2011-06-21, 08:20 (No subject) |
|
|
| |
|
DSB
Developer
Age: 41
Joined: 30 Apr 2004
Posts: 16073
Location: Reichenberg bei Würzburg
|
|
Posted:
2011-06-21, 10:42 (No subject) |
|
see pm
_________________
Gruß / Greetings, DSB
Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.
|
|
| |
|
|
|
