Welcome to Abdul Malik Ikhsan's Blog

backup and restore di mysql via command line

Posted in Uncategorized by samsonasik on August 6, 2009

Karena keterbatasan phpmyadmin dalam mengeksekusi stored procedure , view, dan trigger, maka kita bisa menggunakan cara lama, yaitu via command line, he.he..

Untuk Linux(dengan web container lampp, kita harus setting dulu, bisa ditambahkan di rc.local )

mkdir /var/run/mysqld

ln -s /opt/lampp/var/mysql/mysql.sock /var/run/mysqld/mysqld.sock

mkdir /var/lib/mysql

ln -s /opt/lampp/var/mysql/mysql.sock /var/lib/mysql/mysql.sock

Untuk mysqldump :

a. di windows :

b. di Linux

Untuk restore :

a. di windows :

b. di Linux:

2 Responses

Subscribe to comments with RSS.

  1. Mas Dhani said, on September 30, 2009 at 3:15 pm

    OOOOOO gitu toooh..

  2. Mas Dhani said, on September 30, 2009 at 3:23 pm

    Akhirnya mysql ku jalan lagi…


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: