| Previous topic :: Next topic |
| Author |
Message |
mrnikeswsh
Joined: 05 Mar 2007
Posts: 29
|
| Posted: Thu May 31, 2007 5:00 pm Post subject: I screwed up.... NEED HELP! |
|
|
Ok.. I think I messed up..I now need to re-install 5.0.2 and restore a database backup.
I have 5.0.2 installed, but I can't figure out how to restore a backup.
I have a backup file called back_today data.SQL
How to I restore this back to Vtiger 5.0.2
Thanks.
BRIAN |
|
| Back to top |
|
Galactic Dominator
Joined: 18 Oct 2006
Posts: 161
|
| Posted: Thu May 31, 2007 5:12 pm Post subject: I screwed up.... NEED HELP! |
|
|
you have to run it in mysql. it's a series of sql statements that will recreate the db.
http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/2/ |
|
| Back to top |
|
mrnikeswsh
Joined: 05 Mar 2007
Posts: 29
|
| Posted: Thu May 31, 2007 6:41 pm Post subject: Re: I screwed up.... NEED HELP! |
|
|
THanks for the infomation,. However when I try to do that. I get the following error.
C:\Program Files\vtigercrm5\mysql\bin>mysql -u root -h localhost -P 3307 vtigerc
rm502 < good.sql
ERROR 1050 (42S01) at line 1: Table 'vtiger_account' already exists
any thoughts?
BRIAN Z |
|
| Back to top |
|
Galactic Dominator
Joined: 18 Oct 2006
Posts: 161
|
| Posted: Thu May 31, 2007 6:50 pm Post subject: Re: I screwed up.... NEED HELP! |
|
|
| delete the old db and create a blank one same name |
|
| Back to top |
|
Galactic Dominator
Joined: 18 Oct 2006
Posts: 161
|
| Posted: Thu May 31, 2007 6:51 pm Post subject: Re: I screwed up.... NEED HELP! |
|
|
| better make sure that backup is good first however...examine the sql or explode it in a new db. |
|
| Back to top |
|
mrnikeswsh
Joined: 05 Mar 2007
Posts: 29
|
| Posted: Thu May 31, 2007 7:08 pm Post subject: Re: I screwed up.... NEED HELP! |
|
|
ok..I think I am getting further
still getting this error
mysql -u root -h localhost -P 3307 new < 2
.sql
ERROR 1005 (HY000) at line 1: Can't create table '.\new\vtiger_account.frm' (err
no: 150)
C:\Program Files\vtigercrm5\mysql\bin>
could it be permissions? Why can't I create the table? |
|
| Back to top |
|
Galactic Dominator
Joined: 18 Oct 2006
Posts: 161
|
| Posted: Thu May 31, 2007 7:37 pm Post subject: Re: I screwed up.... NEED HELP! |
|
|
google is your friend
http://forums.mysql.com/read.php?28,49828,49978#msg-49978 |
|
| Back to top |
|
mrnikeswsh
Joined: 05 Mar 2007
Posts: 29
|
| Posted: Thu May 31, 2007 10:42 pm Post subject: Re: I screwed up.... NEED HELP! |
|
|
thanks...that worked...
but now on to the next problem.
SQL syntax errors. I guess this is my fault..for thinking the DUMP file would just go back in to mYSQL.
I have found that every CONTACT that had a 's had an error.
For example. brian's market or vtiger's customer....or john's body shop... etc
I manually changed the contacts with that ..then found that names were giving me a problem. such as O'donnel or O'neil. etc.
SEE ERROR BELOW.....
ERROR 1064 (42000) at line 11240: You have an error in your SQL syntax; check th
e manual that corresponds to your MySQL server version for the right syntax to u
se near 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US
; mso-bid' at line 1 |
|
| Back to top |
|
Galactic Dominator
Joined: 18 Oct 2006
Posts: 161
|
| Posted: Thu May 31, 2007 11:56 pm Post subject: Re: I screwed up.... NEED HELP! |
|
|
| what version of mysql are you running? There may have been a relevant fix introduced in 5.0.25 |
|
| Back to top |
|
mrnikeswsh
Joined: 05 Mar 2007
Posts: 29
|
| Posted: Fri Jun 01, 2007 12:10 am Post subject: Re: I screwed up.... NEED HELP! |
|
|
that is what I am trying now... i have the 5.0.2 install and I am putting it on a NEW MACHINE..then I will try to import the .SQL file on this machine that has never seen 5.0.3
is the SQL dump/restore usually a SIMPLE THING?
How can I tell SQL versions? I had 5.0.2 until this afternoon.. I have several dumps from the past week as 'backups'
brian |
|
| Back to top |
|
| |
