Hi,
I am trying to transfer data from one database to another. Both are on different servers. I am using phpadmin to do a dump of the tables and data to generate a script I can use.
I am having a problem when inserting data into the tables with the scripts.
Consider the following ...
insert into designs values ('','Picture Publishing','This isn't a nice picture');
because of the ' in the "isn't" an error is caused.
The tables are pretty big and I need these characters in the descriptions. Does anyone have a quick work through usine these pre-generated insert scripts?
I would be really grateful!!
Thanks,
Fiona
I am trying to transfer data from one database to another. Both are on different servers. I am using phpadmin to do a dump of the tables and data to generate a script I can use.
I am having a problem when inserting data into the tables with the scripts.
Consider the following ...
insert into designs values ('','Picture Publishing','This isn't a nice picture');
because of the ' in the "isn't" an error is caused.
The tables are pretty big and I need these characters in the descriptions. Does anyone have a quick work through usine these pre-generated insert scripts?
I would be really grateful!!
Thanks,
Fiona