How can I import a MySQL dumpfile into my database? - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more
Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more
Go Back   Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more > Webmaster Tech > Databases - MySQL, SQL, Oracle, Access and others

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 03-09-2011, 04:07 AM   #1 (permalink)
Junior Member
 
Join Date: Mar 2011
Posts: 40
Default How can I import a MySQL dumpfile into my database?

How can I import a MySQL dumpfile into my database? My old hosting provider gave me data.sql file. I do have access via ssh to server.

Can anybody give light on this?
wulaishiwo is offline   Reply With Quote
Sponsored Links
Old 03-14-2011, 06:59 PM   #2 (permalink)
Regular User
 
Join Date: Jul 2005
Posts: 47
Default Re: How can I import a MySQL dumpfile into my database?

Here's a command to restore the database using the file if you have command line access.

mysql -u USER -p DBNAME < data.sql
sandman is offline   Reply With Quote
Old 04-07-2011, 05:21 AM   #3 (permalink)
Junior Member
 
Kelly_Infrenion's Avatar
 
Join Date: Apr 2011
Posts: 8
Default Re: How can I import a MySQL dumpfile into my database?

Quote:
Originally Posted by sandman View Post
Here's a command to restore the database using the file if you have command line access.

mysql -u USER -p DBNAME < data.sql
Hello,

To use above command you must have a ssh access to the server, else you can request it to restore to your hosting provider.

Thanks!
Kelly_Infrenion is offline   Reply With Quote
Old 04-08-2011, 03:42 AM   #4 (permalink)
Regular User
 
Join Date: Apr 2011
Posts: 115
Default Re: How can I import a MySQL dumpfile into my database?

there is another way, download any sql gui tool, connect it using ur credentials and ip, then restore ur db, selecting ur appropriate database.u need to upload ur sql file here
chunnilal is offline   Reply With Quote
Old 04-17-2011, 06:34 PM   #5 (permalink)
Junior Member
 
Join Date: Apr 2011
Posts: 3
Default Re: How can I import a MySQL dumpfile into my database?

If you cannot access SSH and use the command posted above, you can also use phpMyAdmin import function. You will have to set the max uploadable file size though via the my.cnf file.
AdM.as is offline   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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



» Sponsors

» Links

» Affiliates
Web Hosting
Online Backup Reviews
Marketing Find
Merchant Select
SiteMap Builder
Host Compare

» Links

» Sports Network
Paintball Forum
Football Forum
Hockey Forum
Golf Forum
Boxing Forum
Lacrosse Forum
Baseball Forum
SnowBoarding Forum
Soccer Forum
MMA Forum


All times are GMT -4. The time now is 08:04 AM.


Powered by vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.2
Webmaster Forums
Web Hosting | Chicago Web Hosting | Web Hosting