/    Sign up×
Community /Pin to ProfileBookmark

Importing large .sql file

Copy linkTweet thisAlerts:
Feb 22.2009

Hi,
I have an exported sql file with 35MB of size. And i would like to import it online to my site using PhpMyadmin, but it hangs.
Anyone got idea how to import this mysql file?
The host is not responding to solve this problem. Iam looking for an alternative solution.

Thanks in advance
M

to post a comment
PHP

3 Comments(s) ↴

Copy linkTweet thisAlerts:
@criterion9Feb 22.2009 — If you have access to the command line and a simple web server from your end you can use wget xxx.xxx.xxx.xxx/your_file.sql (where xxx=your IP) and then execute it as a local file from the server.
Copy linkTweet thisAlerts:
@skywalker2208Feb 22.2009 — I have used big dump when I didn't have command line access and the file was to large for php my admin.
Copy linkTweet thisAlerts:
@themoonauthorFeb 22.2009 — Thanks all,

I will try BigDump as i don't have shell access.

Thanks again

M
×

Success!

Help @themoon spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 6.17,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...