When I first started down this slippery slope 2 or 3 weeks ago, I first tried to download and install 5.1 on my local system. I can't remember the problem now, but I could never get it to install, gave up, and went to 5.0 Here is the info on what I am using:
Enter password: *********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 107
Server version: 5.0.77-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
I am running this on an HP Xeon workstation, with XP professional SP 3.
Here is some more info:
I have a much smaller file in another Access database, with around 2200 records. I used Navicat to import this file, VerifiedMembers, into the MySQL database on Bluehost. Then I closed Navicat, opened the CCVF.mdb file, and linked to VerifiedMembers with ODBC. I can easily open the table in datasheet view and everything looks perfect.
So, I am beginning to think that there is something about the way my big files are uploaded that prevents me from seeing the data. I can't use Navicat because there is a 51.5 MB limit imposed by Bluehost for uploading. Basically I had to download a large self-extracting CSV file, extract it, use Navicat to import the text file into a local MySQL table (already set up with the correct structure), then use MySQL to dump an SQL table file. After zipping with WinZip, the file was below the 51.5 MB limit, and I could use file manager on my Bluehost cPanel to extract it. Finally, I used Putty execute the .sql file and create the tabel in my online database. I had to use Navicat because the CSV file has dates as M/D/YYYY and I couldn't find a way to get the date information correctly into the MySQL table. Navicat seems to take care of this problem, and the table winds up with the correct date values in Bluehost.
Enter password: *********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 107
Server version: 5.0.77-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
I am running this on an HP Xeon workstation, with XP professional SP 3.
Here is some more info:
I have a much smaller file in another Access database, with around 2200 records. I used Navicat to import this file, VerifiedMembers, into the MySQL database on Bluehost. Then I closed Navicat, opened the CCVF.mdb file, and linked to VerifiedMembers with ODBC. I can easily open the table in datasheet view and everything looks perfect.
So, I am beginning to think that there is something about the way my big files are uploaded that prevents me from seeing the data. I can't use Navicat because there is a 51.5 MB limit imposed by Bluehost for uploading. Basically I had to download a large self-extracting CSV file, extract it, use Navicat to import the text file into a local MySQL table (already set up with the correct structure), then use MySQL to dump an SQL table file. After zipping with WinZip, the file was below the 51.5 MB limit, and I could use file manager on my Bluehost cPanel to extract it. Finally, I used Putty execute the .sql file and create the tabel in my online database. I had to use Navicat because the CSV file has dates as M/D/YYYY and I couldn't find a way to get the date information correctly into the MySQL table. Navicat seems to take care of this problem, and the table winds up with the correct date values in Bluehost.