Jump to content
Sign in to follow this  
dekzorro

Camner Nak Backup Data Mysql

Recommended Posts

aku dah buat satu database name: Student; table: subjek. skang ni camne aku nak buat backup utk database tuh. MySQL yg aku guna tu skali ngan WAMP5 (3+1), mySQL version 4.x.x.

aku ada jumpa dlm itenet, code:

Backup your Data

mysqldump -uUsername -p dbname > dbname.sql 

laman:

www.theprojects.org

tapi aku tak paham la nak guna code tu..sesapa tlg ajar skit.

Edited by dekzorro

Share this post


Link to post
Share on other sites

ohhh...En.sharuzzaman

tq bebanyak...aku dah berjaya buat backup..

kalu nak restore balik..guna kaedah yg sama jugak kan - cuma tukar command lain ...

apa kegunaan import tu??..

mysql -uUsername -p dbname < dbname.sql

Edited by dekzorro

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...