> Hi all, > > I am sorry for asking this in this forum. > Since its urgent and I am sure u experts can give some tips, I am asking > this question here. > > I have a huge database in MYSQL. > > Now I want a copy of it in a windows machine in a Excel form. > > Is there any good way. > > One idea what I got is to convert mysql database in to a word file first > and then word file to excel file. > But I am not sure whether I can do it. >
i'm no expert - seriously! but you could try: mysql control centre (win32) (google will find it for you), i use webmin (rpm or tarball) installed on my linux - quite easy to setup. web access. go to linux ip default port 10000, root login (or setup non-root) go to servers tab, click mysql, click database permission and add your win32-os 'client' pc's ip or "all" (temporary!) to access your db. go back to mysql control centre, add new server, test connection, open your db, right-click table and open-table->return all rows. then save results as text. use excel to open, view all files (including txt format), go thru the 'text import wizaard', tick delimiter coma and textqualifier ' (single quote) good luck, cheers > > Thanks > Geetha Thanu > Bioinformatics > CDFd > > > > ------------------------------------------------------- > This SF.Net email is sponsored by BEA Weblogic Workshop > FREE Java Enterprise J2EE developer tools! > Get your free copy of BEA WebLogic Workshop 8.1 today. > http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click > -- > squirrelmail-users mailing list > List Address: [EMAIL PROTECTED] > List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995 > List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users > ---------------------------------------------- This email was sent from Hock Seng Lee Berhad. http://www.hsl.com.my ------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click -- squirrelmail-users mailing list List Address: [EMAIL PROTECTED] List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995 List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
