Desperate help for non technical person...

[tlck9]

I have done something stupid.....very stupid and Im not sure how to get back to where I need to be

I was using sugar 4.5.1g I have a copy of the folder programfiles>sugarcrm4.5.1g

I was trying to install a completely new 5.2 version of sugar, and keep this as a new installation with non of the 4.5.1g data being carried across..

Thinking I could access both 4.5.1 and 5.2 as I thought I had done with two other versions of 4.5
I was wrong and now have I think written over the data

Although I have a backup copy of the programfiles>sugarcrm-4.5.1g I have no idea how to get it back.Worse to come, so I uninstalled the 5.0 version and thought I would be able to get my old one back which I now cant

So I tried to remove both folders from my program folder and start from scratch.....

So you could say I've messed it all up and dont even know where to start.

I've even tried to install the 4.5.1 onto a different computer, which has worked, but how do I get the data from the folder and populate this copy with my data????

IN an ideal world I would like 5/0 running on my laptop and 4.5.1 running on the other laptop so I can transfer the data as I need it.....but each time I try to install 5.0 it tells me that on 4.5.1 can run 4.5.1 data

Please help.....as you can perhaps tell, I am not at all technical and I will learn from this big mistake
however unless I do make mistakes I will never learn, so huge learning curve

Aprpeciate any help and if you could in big time idiot format that even a idiot like me can follow

really appreciated

(ps I do have a copy of a backup but going back to November, so if I get instructions on how to get this into my new install this would also be helpful

[tlck9]

Please anyone?

I now have a clean install of 4.5.1g on my current machine.

I have a copy of the original folder from the programs folder

and I have a backup copy of the data via BAckup from November

Can someone tell me what information I could copy from the 4.5.1g folder to my clean copy so I can at least look at my database?

Really appreciate any help, as I need to gain access to this, this afternoon to report to my boss, right now I have a blank database and cannot getthe information.

[lduperval]

If you have overwritten your database and you don't have a backup, I'm not sure there is much you can do.

Did you restore the backup database using the MySQL tools? That should be all you need to do. Your installation should point to the correct database, and as long as there is data in it it will read it.

If you want to run 4.5.1 and 5.x simultaneously, I think you will need to do the following:

• Make a copy of your 4.5.1 database into a new database, for example, sugarcrm5
• Install 5.x by saying it is an upgrade, but tell the installer to use database 'sugarcrm5'
• Use different URLs if the servers are running on the same machine. For example http://localhost/sugar4 and http://localhost/sugar5

Now, I am saying all of this wihout having tested it. However, if I had to do what you are doing, these are probably the steps I would follow.

Good luck,

L

[ronaldo]

To restore your old version of the SugarCRM you need a backup of database.
Use a tool for MySQL to manager your database and restore it.

The steps to restore your SugarCRM 4.5.1 are:
1. Copy your backup of programfiles>sugarcrm4.5.1g to this location again;
2. Restore your database backup in MySQL.
2. Edit <sugar folder>/config.php and verify if:
- 'db_host_name' => '<ip or host of the machine with mysql>';
- 'db_user_name' => '<user with permissions to access to database>';
- 'db_password' => '<database user password>',
- 'db_name' => 'The database name used after you restore it',
If this variables are ok, your SugarCRM 4.5.1 will be ready to work.

[tlck9]

I appreciate you both responding to my plee!!!

I have two things, a copy of the original folder

C:Programfiles>Sugarcrm 4.5.1g

I also have a backup, made via the backup on Sugar Admin section, rather than one through Mysql tools?


May be a silly question, but where can I find a tool to restore the data???
I have found phpMyadmin - if this is what you mean, do you know what I have to follow to restore this database

As I said I am a complete novice, but I want to learn and can follow exact instructions, so hopefully I can get my data back into the folder....

So I would overwrite the Crogramfiles>sugarcrm 4.5.1g with the copy I have in my documents>Sugarcrm 4.5.1g

Then I get stuck, how do I restore databack back in SQL?

(sorry to be thick on this)

[tlck9]

Sorted thank you....

I dowloaded a free MYSQL management software from SQLManager.net (EMS SQL freeware), this allowed me to access the database, following the restore instructions on the wiki, which tells you to dump the database attached, which after taking a copy before dumping. I then copied the sugarcrm folder from the Mysql>data> folder back into the original install folder under program>Sugarcrm 4.5.1g>MYSQL>data

I tried to move this before using the management but it would always come up with permission errors, or that the file was in use

Anyway after dumping the database, it allowed me to copy this original copy of the sugarcrm database and paste into this folder.

and it worked.....

learnt the lesson of backing up, and knowing what to do in the event of having to restore.....I still have yet to find what the backup in the sugar admin actually does...so appreciate any comments