MySQL Forums
Forum List  »  Backup

backup stored procedures and change parameter names
Posted by: Chagh
Date: August 24, 2005 03:23AM

hi all,
i've got a problem in restoring my stored procedures. i back up proc table of mysql daabse to back up my SPs. it can easili be restored.

i would like to change name of parameters of my SPs, so i thaught baching them up(dumping them with mysqldump) from mysql db and then changing these parameters using a text editor would solve my problem(there are so many parameter names that should change so i don't want to change them manually by editing the SP)
when i try to restore the changed parameters file with mysql it gives me this error:

"ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use near 'n++
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at line 1"
(it is not really n++ in the error, these are strange characters instead)

why does this happens? i looked at the sql file but i couldn't see any strange characters and it didn't have changed but the change of name of parameters.

What should i do to change my parameters name in an easy and non-time-consuming way?

Thanks in advance
Chagh

Options: ReplyQuote


Subject
Views
Written By
Posted
backup stored procedures and change parameter names
6466
August 24, 2005 03:23AM
3544
September 30, 2005 12:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.