Hi Voytek
You could try some variation of:
INSERT INTO inserttable (user, maildir)
SELECT REPLACE(user, '@', 'spam@') as user, CONCAT(maildir,'.spam/')
as maildir
FROM selecttable
[WHERE ..]
the where bit is optional of course!
let me know how you go - hope you are keeping well!
ray
At 03
Have you tried using the
> use db
> source /path/to/dumpfile.sql
command via the mysql command line client?
At 08:28 AM 5/20/2007, Vitaliy Okulov wrote:
Çäðàâñòâóéòå, mysql.
How i can speedup restore of mysql DB from file created by mysqldump?
MySQL is quite fast at reloading data, but if