Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tchongtching
Starting Member
3 Posts |
 Posted - 2010-01-12 : 20:59:42
|
| hi,my problem is i am trying to restore a sql database for joomla,and i have used lazybackup (i figured out why its lazy)sadly lazy backup has backedup using only one long description:and the word "VALUES" dont always contain the long description and a line break:example of wrong code:INSERT INTO `crawlt_attack` VALUES(1, 'tpl_pgb_moddir=, 'PostGuestbook (PHP-Nuke module), 'css'), VALUES(2, 'vwar_root=, 'Virtual War, 'css'), VALUES(3, 'mosConfig_absolute_path=, 'JoomlaPack (Joomla module), 'css'), VALUES(4, this is what i wantINSERT INTO crawlt_attack VALUES(1, 'tpl_pgb_moddir=', 'PostGuestbook (PHP-Nuke module)', 'css');INSERT INTO crawlt_attack VALUES(2, 'vwar_root=', 'Virtual War', 'css');INSERT INTO crawlt_attack VALUES(3, 'mosConfig_absolute_path=', 'JoomlaPack (Joomla module)', 'css');does anybody know a trick or a code to adapt these automatically on all the page (there are many different variants),or is there a program on osx allowing to simply rename these ?thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tchongtching
Starting Member
3 Posts |
Posted - 2010-01-13 : 16:36:26
|
| hi thanks for your answermy sql is on a linux server # Server version: 5.0.67.d7-ourdelta-loghosted at godaddy,can you help me ?thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tchongtching
Starting Member
3 Posts |
Posted - 2010-01-13 : 17:20:49
|
| thanks i didnt realize that |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Need help with database backup sql