If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Import more than 50 MB of MYSQL database ???

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-04-10, 05:20
ethanwaber ethanwaber is offline
Registered User
 
Join Date: Aug 2010
Location: toys store and bakugan toys
Posts: 1
Import more than 50 MB of MYSQL database ???

hi, I'm newbie here

If anyone could help me to import my database with size 260 mb???

Thanks

regards
ethan
Reply With Quote
  #2 (permalink)  
Old 09-04-10, 09:34
sco08y sco08y is offline
Registered User
 
Join Date: Oct 2002
Location: Baghdad, Iraq
Posts: 697
You do the same thing as if you were to import a database of 1 MB or 1 TB.

You need to know what format your files are in.

You need to know what schema your files have.

You need to set up MySQL to have the right schema.

You need permissions on MySQL to write data.

You need to set up a script to read the files and write the data to MySQL, probably using mysqlimport.

Now, which of those do you need help with?
Reply With Quote
  #3 (permalink)  
Old 09-06-10, 13:02
uhm uhm is offline
Registered User
 
Join Date: Mar 2010
Posts: 8
are you talking about the limitations imposed by your hosting company?

In that case many hosts allow you to upload your sql file to your website, and they'll import it via command line for you.

Otherwise you can split it in parts smaller than the maximum file size allowed by your host. To do this simply open your file with an editor that can handle large files ( programmers notepad, intype etc), and consecutive save parts of that file into separate files and import them via phpmyadmin.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On