how can we take backup of a database with shutdown the server in mysql.
srpa01red 0 Newbie Poster
mwasif 10 Posting Whiz
Copy .FRM, .MYD and .MYI files from the database directory. But you can do this only with MyISAM tables.
bhanu1225 0 Junior Poster in Training
Here is another way for backup.
mysqldump -u [username] -p [password] [databasename] >
[backupfile.sql]
*[username] - this is your database username
*[password] - this is the password for your database
*[databasename] - the name of your database
*[backupfile.sql] - the file to which the backup should be written.
Try this, it would work.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.