Pages: [1]   Go Down
Send this topic | Print
Author Topic: TIPS : Export (phpMiniAdmin) and Import (BigDump) Database  (Read 3523 times)
Dark Raito
Dark Templar
Loyal 110MB Member
*******
Offline Offline

Posts: 2280


i seems to prefer to read more than to post more..


WWW
« on: December 23, 2006, 03:19:59 AM »

First of all, both 2 scripts came from 2 different people. thus, its nothing related. Now, lets proceed to the steps.. Clicking the name will made you download the file directly

Importing Database (with phpMiniAdmin)
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
1. login to phpMiniAdmin
2. select your database
3. click export data and save the file
4. open the SQL dump data file
5. click dump structure
6. select and copy all the structures
7. paste above the SQL dump data

Exporting Database (with BigDump)
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
uhh.. browse your sql dump and click "upload".. lawlz.. i cant tell you anything coz, its plain obvious. anyway, please do edit the file before uploading them.

Quote from: bigdump.php
USAGE

1. Adjust the database configuration in this file
2. Drop the old tables on the target database if your dump doesn't contain "DROP TABLE"
3. Create the working directory (e.g. dump) on your web-server
4. Upload bigdump.php and your dump files (.sql, .gz) via FTP to the working directory
5. Run the bigdump.php from your browser via URL like http://www.yourdomain.com/dump/bigdump.php
6. BigDump can start the next import session automatically if you enable the JavaScript
7. Wait for the script to finish, do not close the browser window
8. IMPORTANT: Remove bigdump.php and your dump files from the web-server

note  : it was Mr. Rod who found BigDump script in the depth of the vast internet sea.
note2 : its nice to see people dont have problem with the TIPs ^^
« Last Edit: December 23, 2006, 07:30:32 PM by DarkRaito » Logged


110MB.com Help!
NubsPixel.com
Quote from: 'A Wise person'
have you ever faced failures?

never. because there is no such thing as failure.
Only lessons that make you a more better person.
Mr. Rod
Hyper-Active Member
***
Offline Offline

Posts: 160


WWW
« Reply #1 on: December 23, 2006, 05:17:07 AM »

Thanx for the credits cheesy

Also it's VERY important to delete the bigdump.php file or rename it to something else you only know once you are done importing your database, because eventually your database can result screwed by someone else!

PS: bigdump also allows .gzip
« Last Edit: December 23, 2006, 05:19:52 AM by Mr. Rod » Logged
Piotr GRD
Honoured 110MB Member
Official 110mb Guru
*****
Offline Offline

Posts: 6664



WWW
« Reply #2 on: December 25, 2006, 05:12:40 PM »

Yesterday the BigDump was inacessible for me (and not only for me). Today I can download it so... this is an alternative sourse of BigDump for everyone: http://grd.110mb.com/export/bigdump.zip

You also can export and import the database with MySQL-Admin 3.3 http://sourceforge.net/projects/mysql-admin/ but when importing you have to split the .sql file because (in my case) it doesn't work with files larger then 2 MB.
Logged

Dark Raito
Dark Templar
Loyal 110MB Member
*******
Offline Offline

Posts: 2280


i seems to prefer to read more than to post more..


WWW
« Reply #3 on: December 25, 2006, 08:40:19 PM »

the links works fine with me... weird..
Logged


110MB.com Help!
NubsPixel.com
Quote from: 'A Wise person'
have you ever faced failures?

never. because there is no such thing as failure.
Only lessons that make you a more better person.
zdig1
Active Member
**
Offline Offline

Posts: 77


« Reply #4 on: January 09, 2007, 06:46:56 PM »

pah admin dont work on box2
try to use mysqldumper
nice to import and expeort
but i thin sql in box 2 also have a pb
so try to repair it ( i dont know how )
Logged
Mr. Rod
Hyper-Active Member
***
Offline Offline

Posts: 160


WWW
« Reply #5 on: January 13, 2007, 12:08:05 PM »

Due to server changes MySQL and logins may not work untill works are finished... already explained in the Technical board wink
Logged
kobbey
Member
*
Offline Offline

Posts: 6


« Reply #6 on: February 22, 2007, 09:22:09 AM »

 :?AARGHHH !
I wanted to save my SQL on hard disk so i could change it a bit and put on the other server, but it says i dont have a permits to do that ? ? ? What, i say !?
 huh
i used this lame phpminiadmin, and it didnt work, HELP @ !!
Logged
canerce
Active Member
**
Offline Offline

Posts: 80

www.canerce.com


WWW
« Reply #7 on: February 22, 2007, 10:24:00 AM »

look thi topic  wink http://www.110mb.com/forum/index.php/topic,3721.msg51780.html#msg51780  afro
Logged
Dark Raito
Dark Templar
Loyal 110MB Member
*******
Offline Offline

Posts: 2280


i seems to prefer to read more than to post more..


WWW
« Reply #8 on: February 23, 2007, 03:57:38 AM »

this is outadated...

Locked.
Logged


110MB.com Help!
NubsPixel.com
Quote from: 'A Wise person'
have you ever faced failures?

never. because there is no such thing as failure.
Only lessons that make you a more better person.
Pages: [1]   Go Up
Send this topic | Print
Jump to: