jeffblochjr

Thanks; specifying the correct path seemed to work!

Can anyone tell me what these errors mean? This happens when I try to access a specific page on my site... however, it did NOT used to happen when this same site was hosted on a different server. Suggestions? (To make this stuff not run off the screen, I substituted \"<A LOT OF NUMBERS AND LETTERS HERE>\" for a long string of numbers and letters.) Warning: Failed opening \'loginform.php\' for inclusion (include_path=\'\') in /home/owedmone/public_html/phplib/local.php on line 60 Warning: Failed opening \'loginform.php\' for inclusion (include_path=\'\') in /home/owedmone/public_html/phplib/local.php on line 60 Database error: Invalid SQL: insert into active_sessions ( sid, name, val, changed ) values (\'67ecd788ed19c49493a8b61321ad2852\', \'my_sid\', \'bXlfc2lkOiR<A LOT OF NUMBERS AND LETTERS HERE>E0NzQ4MzY0Nyc7IA==\', \'20030124080754\') MySQL Error: 1062 (Duplicate entry \'my_sid-67ecd788ed19c49493a8b61321ad2852\' for key 1) Session halted.

When I do a check on these \"corrupted\" tables, I get these messages: Table is marked as crashed and last repair failed Size of datafile is: 14008320 Should be: 0 Can\'t read indexpage from filepos: 147456 Corrupt Any suggestions?

Here\'s yet another problem... everything was going fine, but then I hit a certain file and I did this command as usual: LOAD DATA INFILE \'/var/www/html/data/records_t.txt\' INTO TABLE records_t FIELDS TERMINATED BY \';\' ENCLOSED BY \'\"\' LINES TERMINATED BY \"n\"; However, this time for some reason, I get the following message: Error SQL-query : LOAD DATA INFILE \'/var/www/html/data/records_t.txt\' INTO TABLE records_t FIELDS TERMINATED BY \';\' ENCLOSED BY \'"\' LINES TERMINATED BY "n" MySQL said: Got error 122 from table handler What should I do? How can these tables be corrupt? I just exported the structure from another database and uploaded it to this one. Please help!

As it turns out, I dont have access to edit php.ini, and my web host couldn\'t help me much with it. I did, however, get this whole big problem to solve itself with a simple \"LOAD DATA INFILE...\" command (after uploading these incredible huge text files onto my web site), and it worked like a charm. Thanks for all the help you guys have given me.

If I can get into shell, and I have these huge text files already uploaded to my website... is there a command I can use to import these files into my MySQL database tables?

That\'s gotta be it!! How can I change that value? I just have to get these text files into my database. Is there any way to disable this upload limitation?

I\'m affraid I don\'t know much about mysql or writing scripts... and unfortunately I wouldn\'t know the first thing about writing a script to perform that action. There is no other way to simply upload this textual data into the mysql database? I mean, why isn\'t it working when I tell it to \"Insert data from a textfile into table\"??

My problem is... I have the whole structure of the database all worked out and transferred over. Now I need to move the 700+ meg of data from the old database to the new. I have these 26 data files (text documents) on my hard drive, and I click on \"Insert data from a textfile into table\" for the respective table. Then, I direct it to look at the text file on my hard drive, and click Submit. Then I wait about 3 or 4 minutes... and the page basically reloads itself. No confirmation or error messages... it just reloads and stops reading the file. That\'s it. How else can I get the data from these text files into the tables? Please help, I am stumped.

I am trying to move a mysql database from a site on one server to a new site on a different server. I dumped the old site\'s structure and imported it into a new mysql database on the new web site... but there is 700 meg of data on the old database. 26 text files make up the bulk of this 700 meg, and they must be uploaded to 26 tables on this new mysql database on the new server. When I try to do this via phpMyAdmin, it freezes up on me because it takes so long (I\'m even using a cable internet connection!). What are my other options for uploading the data of these tables? I have to get this information into the new database, but it always times out. Please help! Thanks. Jeff