Hey there, I build today mine article-directory site with a script cald article-live. Now I wanted to use a .msq file of a different script and this .msq file is around 1 gig big. Now first I tried bigdump but it isnt working for me and another problem I am facing is the folowing: The mysql has the folowing instructions: While my tables are the folowing For the content it is using table -> iwp1_articlepages while for the article Id, AuthorID,Title and summary it is using table -> iwp1_articles. My file size limit on phpadmin is around 2 mb so I cant upload at once. Can one of you help me / explain to me how I can fix it. With kind regards,
Well i Succeeded now with bigdump but now i need to copy a table called article_master->Article ID to IWP1_articles->articleID Anybody know how to do this?
try using insert ..select construction http://dev.mysql.com/doc/refman/5.0/en/insert-select.html if it does not work for all table, try limit select by using limit keyword