How do I backup all data, so I can reformat my drive then reinstall Sugar CRM content

[apples017]

Hi,

First time user here. I'm going to try using sugar in the delvery van with a laptop. Long story short is I have two laptops but one is dead because the drive is fried.

I bought an inverter to power the laptop the good one in the truck, but iot does not work with the inverter. SO I am going to try it on the other laptop, but first I will pinch the drive from the good laptop and put it in the bad laptop.

I will have to reformat the drive and re install xp to make the disk work, in doing so I will lose all my sugar data.

How can I copy everything I need onto a portable drive then reinstall it all back onto the fresh copy of xp?

I will be pulling my hair out if I lose all the data I have entered into sugar in the last 3 days........



Then how do I reinstall the saved data back in? Will it just be a simple click and import?

Peter

[SugarDev.net]

What you need to do is backup Sugar's files and Sugar's database using a tools like phpMyAdmin, then just put the files back and use phpMyAdmin again to import the database back. Your Apache/MySQL/PHP setup can be handled by something like WAMP.

Do not rely on Sugar export, you will lose relationships between items.

[apples017]

Okay,

1. phpMyAdmin - This is hosted just on the computer at home, ie not on the internet. is phpMyAdmin only for internet hosted sites? The reason I say this is because I have seen it in my Hostgator control panel.

2. "Your Apache/MySQL/PHP setup can be handled by something like WAMP." umm oaky (have no idea here)

Where I'm at now.
I have just done a clean install of Sugar on to the desktop computer. What are the exact steps to get all my accounts and data over to the desktop computer Sugar installation?

Peter

[SugarDev.net]

If you have not a single customization, you're done with the code.

Use phpmyadmin to export your old db and import it replacing the empty db your new install just created. Do everything with phpmyadmin. It's not a tool for sites, it's a manager for mysql databases. Do an export -> save to file and an import -> from file on the other machine. One issue you might stumble upon is that you export all tables and not the creation of the database, or include the creation of the database while you already have it on the new machine. To prevent this, just make sure you export all tables in the old database (and not the database itself). To do this, first open the database in phpmyadmin and then click on export. On the import, make sure you already have an empty database and open that, then import the export file. You can just remove all tables from the new database prior to importing.

[apples017]

from my desktop (xp) how do I access phpmyadmin?

Peter

[mapm]

in Browser try http://localhost/phpmyadmin

[apples017]

thanks mapm,

now the next step.

I export the.sql file to the other computer
open up phpmyadmin
click on import from the main page
import file, and I get this.

-------------------------------------------------------


Error

SQL query:

--
-- Database: `information_schema`
--
CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL said: Documentation
#1044 - Access denied for user 'root'@'localhost' to database 'information_schema'

-----------------------------------------------------------------------------------------------

[mapm]

Hi,
You dumped all databases in your computer, you should only export the one that you need, and import that one.