Home > Archive > MySQL ODBC Connector > September 2005 > mysqldump and import









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author mysqldump and import
Dwayne Hottinger

2005-09-16, 8:23 pm

I need to do an import of mysql data that I dumped from an older mysql server
the older server is running version 4.1.8 official mysql rpm. The new server
is running the version of mysql that comes with Fedora Core 3. The problem Im
having is with the Charsets that are in the older version. Is there a way to
do a mysql -u root -p somedatabse < somedatabase.sql and have it ignore errors
or the charset stuff? I tried editing the .sql files and it just complains
about something else. Any mysql gurus help would be great. This old server is
going to go belly up soon.

thanks,

ddh


--
Dwayne Hottinger
Network Administrator
Harrisonburg City Public Schools

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Gleb Paharenko

2005-09-17, 9:23 am

Hello.

Oh, no. MySQL which is shipped with FC3 is much older than 4.1.8 (check
it's version). If you can upgrade - use the latest release (4.1.14 now). Search
how to perform a proper upgrade in the archives at:
http://lists.mysql.com/mysql


Dwayne Hottinger < dhottinger@harrisonb
urg.k12.va.us> wrote:
> I need to do an import of mysql data that I dumped from an older mysql server
> the older server is running version 4.1.8 official mysql rpm. The new server
> is running the version of mysql that comes with Fedora Core 3. The problem Im
> having is with the Charsets that are in the older version. Is there a way to
> do a mysql -u root -p somedatabse < somedatabase.sql and have it ignore errors
> or the charset stuff? I tried editing the .sql files and it just complains
> about something else. Any mysql gurus help would be great. This old server is
> going to go belly up soon.
>
> thanks,
>
> ddh
>
>
> --
> Dwayne Hottinger
> Network Administrator
> Harrisonburg City Public Schools
>



--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com