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]
