Hello.
seconds, but my mysql 4.1.10 takes forever to run.
Do the queries never end? Or they're finishing after the long time?
I don't know whether all indexes are rebuilt correctly in the new database
(mysql 4.1.10). How do I know all my previous indexes are in-placed with the
restore?
Use the 'show create table' statement to see information about the table. And
'show index' to get additional info about the indexes.
You may send us an output of the following statements executed on both servers:
show variables;
show status;
sam wun [EMAIL PROTECTED] wrote:
Hi,
I finally got the backup data ported from mysql 5.0 (from freebsd) to mysql
4.1.10 in Redhat. Webmin started up and I can browse the data in each table.
After installed all prerequisit perl modules, and start the web gui and start
to run some queries, I expeirence it runs very slow. A sql in mysql 5.0
finsihed in few seconds, but my mysql 4.1.10 takes forever to run.
I created indexes in mysql 5.0. When doing backup, I use --all-databases and
restore it use command mysql mysql.sql and mysql data.sql.
I don't know whether all indexes are rebuilt correctly in the new database
(mysql 4.1.10). How do I know all my previous indexes are in-placed with the
restore?
Thanks
Sam
--
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]