Results 1 to 8 of 8

Thread: How do I backup my database using MySql?

  1. #1
    apples017 is offline Member
    Join Date
    Jan 2010
    Posts
    8

    Default How do I backup my database using MySql?

    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

  2. #2
    AlexAv's Avatar
    AlexAv is offline Sugar Community Member
    Join Date
    Oct 2009
    Location
    Ukraine
    Posts
    922

    Default Re: How do I backup my database using MySql?

    Hello,

    You can use command (Linux)

    PHP Code:
    sqldump --password=PASS  --opt  DATABASENAME PATH 
    PASS - password
    DATABASENAME - database name
    PATH - path to save dump

    OR you can do it with PHPMyAdmin
    Letrium ltd. - Only high quality service
    http://letrium.com

  3. #3
    apples017 is offline Member
    Join Date
    Jan 2010
    Posts
    8

    Default Re: How do I backup my database using MySql?

    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....

  4. #4
    AlexAv's Avatar
    AlexAv is offline Sugar Community Member
    Join Date
    Oct 2009
    Location
    Ukraine
    Posts
    922

    Default Re: How do I backup my database using MySql?

    OK. How you can get an access to a database?
    And what a system do you use? (Windows, Linux)
    Last edited by AlexAv; 2010-01-28 at 12:32 PM.
    Letrium ltd. - Only high quality service
    http://letrium.com

  5. #5
    apples017 is offline Member
    Join Date
    Jan 2010
    Posts
    8

    Default Re: How do I backup my database using MySql?

    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

  6. #6
    AlexAv's Avatar
    AlexAv is offline Sugar Community Member
    Join Date
    Oct 2009
    Location
    Ukraine
    Posts
    922

    Default Re: How do I backup my database using MySql?

    At first, download phpMyAdmin
    Unzip to a root web directory
    Configure phpMyAdmin. See this link.
    Letrium ltd. - Only high quality service
    http://letrium.com

  7. #7
    mikesolomon is offline Sugar Community Member
    Join Date
    Feb 2008
    Location
    UK
    Posts
    1,467

    Default Re: How do I backup my database using MySql?

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

    It a great tool for managing mysql databases
    Mike Solomon
    Development Manager
    Ivy Ltd
    www.ivy.ltd.uk]www.ivy.ltd.uk

    php version 5.2.6
    MySql 5.1.59

  8. #8
    Gyro.Gearless is offline Senior Member
    Join Date
    Apr 2009
    Posts
    47

    Default Re: How do I backup my database using MySql?

    Quote Originally Posted by apples017 View Post
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Backup/restore (not database)
    By ljkiter in forum Developer Help
    Replies: 8
    Last Post: 2010-06-03, 03:03 PM
  2. How to delete old MySQL backup files
    By Proware in forum Help
    Replies: 2
    Last Post: 2008-06-08, 11:18 AM
  3. Backup Sugar & database?
    By hanjayac in forum Help
    Replies: 7
    Last Post: 2008-03-13, 08:49 AM
  4. Database backup
    By ramji123 in forum Help
    Replies: 17
    Last Post: 2007-02-23, 06:12 AM
  5. Automating MySQL backup
    By Proware in forum Help
    Replies: 0
    Last Post: 2006-07-28, 11:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •