how do we take a backup of mysql database

i want to know the software used

and the process also

 

Your host should provide some MySQL interface (PhpMyAdmin or similar).

From there you will be able to dump or export your database.

Some hosts also provide some automatic or on-demand backup server side. Ask your hosting company

 

the databse is in my desktop
i want to upload it

 

Do you have it as an SQL file or do you need first to dump it from your local MySQL installation ?
What MySQL manager is installed on your remote server ?

Please provide some informations if you want people to help you.

 

i don`t know any mysql manager
i dowloaded my sql and then mysql query browser

 

u are an expert do u know how to upload data from a html table to mysql

 

also load data infile pasth on a webserver when we host

 

there are many ways.
SSH into the box and write this
mysql -u dbusername -p dbname < backupfile.sql

Or use a windows based mysql client like mysqlfront or mysqlyog.

Or use phpmyadmin, and use imort db feature, it will make it work.

 

Hello

If you are using cPanel then go to
MySQL and then go to PHPMYADMIN (look at the bottom) and then select the database you have and hit export.

There hit select ALL and don't forget to click save file.

Then hitting "Go" will give you file you want. Save that file on your computer.

Thats it.

 

HY ,

I am amit U can back up your databse using the CSV(comm sepreted values)
files.
You can converte your output in any type of file extension like .txt ,.pdf etc.

Even you can convert your hole database in any file extension using CSV.

 

mysql -u dbusername -p dbname < backupfile.sql is the prefered way - because of speed. NaviCat can also take and restore backups. Otherwise, just create a SQL script as a backup, then drop and recreate tables and data with SQL Script

 

thanx for u r help it was nice to be under your guidance

 

Helped me out too! THANKS!