Re: mysqldump and import

2005-09-17 Thread Gleb Paharenko
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 [EMAIL PROTECTED] 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
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   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/[EMAIL PROTECTED]



mysqldump and import

2005-09-16 Thread Dwayne Hottinger
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/[EMAIL PROTECTED]