Andrew J Posted July 15, 2004 Posted July 15, 2004 How to split a 1.5MB SQL file and upload the parts? Osc could not handle sql file with this size.
Guest Posted July 16, 2004 Posted July 16, 2004 a 1/5mb size file is a piece of cake, i deal with 20 mb and more files all the time, some up to 300 mb for products, overall size of some of the other databases i deal with are a few gig, if mysql/osc could not handle a file that size, there would not be the following osCommerce has . . . so rethink what you are trying to do, then post your question on what you were doing and how could we help you, dont blame the software. more an operator error.
user99999999 Posted July 16, 2004 Posted July 16, 2004 You can use any decent text editor like ultraedit. Usually the default settings for php are 2M file size and 30sec execution time, so if your getting errors in phpMyAdmin you might look into changing those settings in php.ini. The best way is to FTP the file and use mysql command line from telnet.
Andrew J Posted July 16, 2004 Author Posted July 16, 2004 I didnt mean to blame the software. I posted my problem many time: http://www.oscommerce.com/forums/index.php?act=ST&f=1&t=102526 http://www.oscommerce.com/forums/index.php?act=ST&f=11&t=102520 Older backups around 600K can upload easily. But this 1.5MB wont. It stops with this message: 1170 - BLOB column 'post' used in key specification without a key length create table ibf_posts ( pid int(10) not null auto_increment, append_edit tinyint(1) default '0' , edit_time int(10) , author_id mediumint(8) default '0' not null , author_name varchar(32) , use_sig tinyint(1) default '0' not null , use_emo tinyint(1) default '0' not null , ip_address varchar(16) not null , post_date int(10) , icon_id smallint(3) , post text , queued tinyint(1) , topic_id int(10) default '0' not null , forum_id smallint(5) default '0' not null , attach_id varchar(64) , attach_hits int(10) , attach_type varchar(128) , attach_file varchar(255) , post_title varchar(255) , new_topic tinyint(1) default '0' , edit_name varchar(255) , PRIMARY KEY (pid), KEY topic_id (topic_id, author_id), KEY author_id (author_id), KEY forum_id (forum_id, post_date), KEY post (post) ) [TEP STOP] I tried through phpmyadmin it stops without any sign. No timeout message, nothing.
scotte Posted July 16, 2004 Posted July 16, 2004 That is a databse error, it is corrupted!! Its saying one of they keys lengths has not been set ie its character limits
Guest Posted July 16, 2004 Posted July 16, 2004 I didnt mean to blame the software.I posted my problem many time: http://www.oscommerce.com/forums/index.php?act=ST&f=1&t=102526 http://www.oscommerce.com/forums/index.php?act=ST&f=11&t=102520 Older backups around 600K can upload easily. But this 1.5MB wont. It stops with this message: 1170 - BLOB column 'post' used in key specification without a key length create table ibf_posts ( pid int(10) not null auto_increment, append_edit tinyint(1) default '0' , edit_time int(10) , author_id mediumint(8) default '0' not null , author_name varchar(32) , use_sig tinyint(1) default '0' not null , use_emo tinyint(1) default '0' not null , ip_address varchar(16) not null , post_date int(10) , icon_id smallint(3) , post text , queued tinyint(1) , topic_id int(10) default '0' not null , forum_id smallint(5) default '0' not null , attach_id varchar(64) , attach_hits int(10) , attach_type varchar(128) , attach_file varchar(255) , post_title varchar(255) , new_topic tinyint(1) default '0' , edit_name varchar(255) , PRIMARY KEY (pid), KEY topic_id (topic_id, author_id), KEY author_id (author_id), KEY forum_id (forum_id, post_date), KEY post (post) ) [TEP STOP] I tried through phpmyadmin it stops without any sign. No timeout message, nothing. Seems there is a problem in this table, namely this section: KEY post (post) ) BLOB column 'post' used in key specification without a key length
Andrew J Posted July 16, 2004 Author Posted July 16, 2004 You can use any decent text editor like ultraedit. Usually the default settings for php are 2M file size and 30sec execution time, so if your getting errors in phpMyAdmin you might look into changing those settings in php.ini. The best way is to FTP the file and use mysql command line from telnet. upload_max_filesize is 10M post_max_size is 8M It should upload a 1.5M file without any problem. Can you drive me through this telnet thing step by step I never used it before. Andrew
scotte Posted July 16, 2004 Posted July 16, 2004 if you want me to help you post your msql query and i will run it on my local server, i can tell you if it is a corrupted file!
Andrew J Posted July 16, 2004 Author Posted July 16, 2004 Seems there is a problem in this table, namely this section: KEY post (post) ) BLOB column 'post' used in key specification without a key length Thx! Im wondering how can work fine my site with this kind of error? Im not a programmer how can I fix this? If one of you tell me what and where should I type or correct in the sql file I will do it.
Andrew J Posted July 16, 2004 Author Posted July 16, 2004 if you want me to help you post your msql query and i will run it on my local server, i can tell you if it is a corrupted file! You mean you need the sql file itself, not?
scotte Posted July 16, 2004 Posted July 16, 2004 yes the thing your trying to upload, its a query, just paste it in here and il test it
user99999999 Posted July 16, 2004 Posted July 16, 2004 Once the .sql has failed make sure you drop the tables or database and start fresh. FTP the .sql file then go to telnet and change to the dir where the file is and put in this command with your info mysql -uMyUserName -pMyPassword MyDatabase < MyData.sql http://dev.mysql.com/doc/mysql/en/mysql.html
Andrew J Posted July 16, 2004 Author Posted July 16, 2004 yes the thing your trying to upload, its a query, just paste it in here and il test it Ill send you by email if you send your address to mine: [email protected]
Andrew J Posted July 16, 2004 Author Posted July 16, 2004 Once the .sql has failed make sure you drop the tables or database and start fresh. FTP the .sql file then go to telnet and change to the dir where the file is and put in this command with your info mysql -uMyUserName -pMyPassword MyDatabase < MyData.sql http://dev.mysql.com/doc/mysql/en/mysql.html huh! this telnet thing is far beyond my knowledge. I will get some help from my friend later how installed my server. :) But thx a lot.
scotte Posted July 16, 2004 Posted July 16, 2004 You need to put a key value for "post" in the error thats showing up. Find the bit that you posted. and then find in that bit "post" and put a kely length! Shuld do the trick!
Andrew J Posted July 16, 2004 Author Posted July 16, 2004 And what is purpose of this post thing? I dont know which key lenght will do. 2, 4, 8 or 16 will good?
scotte Posted July 16, 2004 Posted July 16, 2004 thats what i was wondering too, i would just put a nic elong length, it shouldnt hurt!
Andrew J Posted July 16, 2004 Author Posted July 16, 2004 I figured out! &@>đĐ]^˘˛?!!!!!! This post thing comes from the invision power board because I intalled it several days ago. And OsC backup all the tables including ibf_xxxx tables. I will uninstall the board and start again from the scracht separating the two database somehow.
Andrew J Posted July 16, 2004 Author Posted July 16, 2004 Anyway thanks all of you! It was good practice in the backup & restore world of OsC. Its good to be a part of this great community! " Hmm, this could be a beginning of beautiful friendship" :D
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.