Nukemods Forum  
» Log in
User Name:

Password:

Not a member yet?
Register Now!
» Online Users: 94
8 members and 86 guests
claudiamazzonif, denzk9tistw6iwp, gratoiduat5kmes, howsztoge2xwtp, rivdsercruise, snahwpbaxj2fckc, watcy5gerp, whasst3xniisabs
Most users ever online was 611, 03-21-2008 at 11:10 PM.
» .::.
tattoo fonts
http://www.checkoutmyink.com/category/tattoo-fonts-tattoo

Go Back   Nukemods Forum > General > Open topics

Reply
 
LinkBack Thread Tools Display Modes
importing db in phpMyAdmin
Old
  (#1 (permalink))
Junior Member
 
Status: Offline
Posts: 83
Join Date: Jan 2003
importing db in phpMyAdmin - 04-03-2003, 10:16 AM

I want to import my backuped db (3.2M) in my remote db.
The site and db are in Norway and i'm Romania. I have FTP, shell, phpMyAdmin account.
I manage the db through phpMyAdmin 2.3.3pl1
And the db is MySQL 3.23.51

in phpMyAdmin when I click on my db name and then SQL tab ...i select my backup file from my hdd and i wait to upload the file (64 kbps/s bandwidth) .. but the upload doesn't finish properly. The progress bar of IE goes up to 100% but didn't refresh it. And the upload is not done.

I tried with Opera 6 and after I click to start the upload i get an error "Transmission error - http://mysqlurl.com/read_dump.php".

Is other way to import my backup db?
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#2 (permalink))
Senior Member
 
Status: Offline
Posts: 2,905
Join Date: Sep 2002
04-03-2003, 11:09 AM

You may have to break it up into pieces.
Open your saved sql file in Notpad or Ultraedit or Editplus would be better.
You'll have to go through and selst a portion ata time, copy and paste to new file, save as file1.sql, next section, copy and paste to new text file, save as file2.sql
Takes some time, but with Databases that are a little bigger, phpmyadmin craps out.

Example. There are some 100 Database tables, you may only be able to uplaod 20 ata time cutting the ONE big sql file you have there into 5 smaller sections of it :-)

mikem
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#3 (permalink))
Junior Member
 
Status: Offline
Posts: 83
Join Date: Jan 2003
04-03-2003, 05:07 PM

thank you once more if u don't have enough thanks

it worked even i spend more than 1h...
i had some problems importing some big tables even tryed with 1 sigle table like *posts_text, *search_results or *search_wordlist.

nut it worked nicely...

thanks again
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
editing downloads with phpmyadmin boaw Nuke 7.x - General 0 08-23-2006 10:42 PM
Intalling, phpMyAdmin, and Admin.php Godsquad Nuke 7.x - General 9 01-31-2006 11:14 PM
Getting phpMyAdmin to work VitalSignz Open topics 2 09-18-2005 04:37 AM
Stuck after the query stage of phpMyAdmin 2.3.3 Luie Site design 2 01-24-2003 09:45 AM
Importing SQL files...... tonychaos Purged Topics 5 01-08-2003 10:27 AM




vBulletin Skin developed by: vBStyles.com


LinkBacks Enabled by vBSEO 3.3.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31