Our Wedding Path

Daisypath Anniversary tickers

Wednesday, May 16, 2012

Export / import large database using command prompt

Hi..Assalammualaikum...

Being away toooo long from updating the blog.

Thou i might have a few issues to arise, but the most important thing currently is to post this simple command line (yet always being forgotten...by sapa? Forgotten by me laa.haish!)

There are times when you try to export / import large files of mysql by using the usual import export colourful function features, and the errors pop mentioning the file is too large and bla..bla..bla..

So, please step back to the manual way.

Instead of trying to change the
my.ini files (mysql), php.ini files, config.php.inc files..pleaseeee DO NOT DISTURB those files..BUT If ur smart, still want to change it, do some backup beforehand.(just in case)—still a reminder for me too

USE COMMAND PROMPT...old, classic way..and yet powerful..
No partial import..altogether..JUST DUMP..!

To export / to dump large db
mysqldump -u username -p databasename > filename.sql to export
export

To Import large db
mysql -u username -p databasename < filename.sql

import
Bear in mind, this must been done together. If you dump the db by using the 1st command prompt line, then use the 2nd to import it.

No interference by using interface button colourful import/export button. Arachhi?

Cakap korea la plak..hahaha..

rindunya nk tgk cite korea..wuu wuu~ tapi masa tidak mengizinkan..ops..ehem..english only for this entry.

**the executable files shall be used only on bin environment.(as shown above)

Thats it for today..Have a nice day everyone...

0 notes:

Related Posts Plugin for WordPress, Blogger...