Kevin, Thursday, August 08, 2002, 7:41:30 PM, you wrote: KB> I have access to the database files themselves from a linux KB> installation of mysql, but not the root login priveleges under mysql KB> itself. I know that if I could connect via mysql itself I could just KB> copy the databases from one server to another but I cant. I copied the KB> db files over via ftp onto a windows server running mysql and it sees KB> the 2 databases but if I try to actually access the colums, etc. I get KB> errors. I also noticed the file extensions on the unix files are KB> different, except for the .frm files. Is there an import tool or KB> something else I can run to import these files into the windows version KB> of mysql so that I can start using them again? The web site these are KB> used for is being migrated off unix onto windows. TIA!
You don't need all privileges to make a dump. SELECT_priv on the database that you want to move is enough. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php