Database backup

[ramji123]

Hi,

» Operating system type and version: Windows xp
» Sugar Suite version : 4.5.1 pro
» Webserver type and version :Apache 1.3.31
» PHP version -- 4.3.11
» MySQL server version 5.0.24

I taken sugarcrm files through Admin backup link

but I need to take database backup.

how can i take a database backup.

where i will get this database vendor's documentation.

To backup your database information, refer to your database vendor's documentation.

Please reply ASAP

Thanks

[paikmoses]

Hi ramji123,

You can take the back up through the phpMyAdmin.

To take back-up manully check this out: http://sugarcrm.openapp.org/?p=141

HTH.

Regards,

[TheDonMiguel]

Hi Moses

I tried "your script" once and got this error:

mysqldump: Got error: 1045: Access denied for user 'administrator'@'localhost' (using password: YES) when trying to connect

Do you know how to fix this?

Regards,
Miguel

[ramji123]

Hi paikmoses,

For your suggestion i given this command in linux open terminal

mysqldump -u root -p welcome sugarcrm dump.sql

but i am getting command not found but it's created the dump.sql file 0 bytes.
i am using centos.
any idea

Please reply me ASAP.

Thanks

[paikmoses]

Hi ramji,

Run this command:

$ mysqldump -u User -p DBName > DBDump.sql

This will give you the back-up of the whole structure and data.

Regards,

[paikmoses]

Miguel,

Could you give me the script that you run?

[TheDonMiguel]

Hi Moses,

I runt this batch file on my windows 2003 server:

"D:\SugarCRM\mysql\bin\mysqldump.exe" -u "MyAdmin" -p"MyPassword" -t sugarcrm c:\backup.sql

Thanks,
Miguel

[paikmoses]

Miguel,

Get inside the mysql through command prompt, then run the command:

$ mysqldump -u User -p DBName > DBDump.sql

This will give you the dump of structure and data.

Try this and let me know.

Regards,

[ramji123]

Hi paikmoses,

Thanks for your reply.

but i am still getting the same error

bash:mysqldump:command not found

how to get the mysql command line in command line prompt

i am entered this command, under mysql bin folder. but i am getting following erro

[root @ sugarserver bin]# mysqldump -u root -p sugarcrm > sugarcrm1702007.sql
bash:mysqldump: command not found

Any idea?

Thanks

[paikmoses]

ramji123,

Follow these steps to take the dump:

1. Get inside the /mysql/bin
2. Now type this command:

mysqldump -u root -p sugarcrm>backup.sql

Here sugarcrm is the name of the database you want to take the back-up of and backup.sql is the name of the backup file that is created.

After this it will ask you the password for mysql user root. Once this command is executed, it will create the backup.sql file in the bin directory.

Try this out.

Regards,