469,267 Members | 1,066 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,267 developers. It's quick & easy.

Revisiting mysqldump ==> restoration problem

Hello,

I did a server upgrade and at the same time did a mysql update from
4.0.12 to Ver 12.22 Distrib 4.0.16. Essentially, moving from one machine
to another. The dump consists of a cluster of databases, not just one
and a few Tables.

Now I'd like to restore the Database(s) ===>

mach1# mysql --version
mysql Ver 12.22 Distrib 4.0.16, for portbld-freebsd4.9 (i386)

I attempted to restore the DB with

mysql> LOAD DATA INFILE /usr/home/adam/Temp_storage/mysqldump/dump_all;

and got the following Error message ==>

ERROR 1064: You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to
use near '/usr/home/adam/Temp_storage/mysqldump/dump_all' at line 1
mysql>

Inspection of the dumped file ==>

head /usr/home/adam/Temp_storage/mysqldump/dump_all
-- MySQL dump 9.07
--
-- Host: localhost Database:
---------------------------------------------------------
-- Server version 4.0.12-log

--
-- Current Database: bpndb
--
I received several pieces of advice which I followed but with little
success. Currently the dump_file (copy of) has been modified w/ sed to
remove all comment lines, for instance all of those above, all "--",
all "---------------------------------------------------------", all "--
Current Database:xxxxxxxx", etc.

So the file is a bare bones file of CREATE, INSERT command line type
instructions. How can I pass these back into the new mysql? And as we
are at it, how does one restore the original dumpfile into the new
mysql? I am sure someone has been faced with the problem of moving a DB
cluster from one machine to another.

Could someone advise

Thanks
-- Adam --
Jul 20 '05 #1
0 1298

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Adam Smith | last post: by
reply views Thread by Adam Smith | last post: by
3 posts views Thread by Tommy.Vincent | last post: by
1 post views Thread by Tommy.Vincent | last post: by
1 post views Thread by Greg.Harabedian | last post: by
6 posts views Thread by Antoni | last post: by
7 posts views Thread by grace | last post: by
reply views Thread by Now You Know | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.