How do I backup my database using MySql?

[apples017]

How do I backup my database using MySql?

I need to replace the hard drive in my laptop with another. But first I need to get all the info save from sugar crm, so that I can put it all back in the new hard drive.

It is possible to do and the solution I read on the forums is " use mysql admin or somehting to doa back up and the re install the database on the new computer....

Well, umm how do I do this step by step?

Peter

[AlexAv]

Hello,

You can use command (Linux)

 sqldump --password=PASS  --opt  DATABASENAME > PATH 
  

PASS - password
DATABASENAME - database name
PATH - path to save dump

OR you can do it with PHPMyAdmin

[apples017]

AlexAv,

Thanks Alex but, all you guys are php and mysql etc literate. I have never worked with any of that.

So I don't even know where to enter that code.

I used the FastStack installer thingy....

[AlexAv]

OK. How you can get an access to a database?
And what a system do you use? (Windows, Linux)

[apples017]

OK. How you can get an access to a database? I'm asking you that question
And what a system do you use? (Windows, Linux) Windows XP

[AlexAv]

At first, download phpMyAdmin
Unzip to a root web directory
Configure phpMyAdmin. See this link.

[mikesolomon]

Have a look at http://sqlmanager.net/products/mysql/manager

It a great tool for managing mysql databases

[Gyro.Gearless]

How do I backup my database using MySql?

I need to replace the hard drive in my laptop with another. But first I need to get all the info save from sugar crm, so that I can put it all back in the new hard drive.

It is possible to do and the solution I read on the forums is " use mysql admin or somehting to doa back up and the re install the database on the new computer....

Well, umm how do I do this step by step?

Peter

On Linux i use something like:

mysqldump -u root -p --databases sugarcrm | bzip2 > /tmp/backup-mysql-sugarcrm.dump.bz2

to make a complete dump of SugarCRM's database. On Windows, you may want to omit the compression part (or just get bzip for Windows somewhere), so just use:

mysqldump -u root -p --databases sugarcrm > c:\temp\backup-mysql-sugarcrm.dump

HTH
Gyro