bz2 Posted September 23, 2009 Report Share Posted September 23, 2009 Tātad man ir bz2 fails kas sver ap 260mb... Gribēju to uplodot uz phpmyadmin - saliku limitu lai ir 120 gb. Sāku uplodot, pēkšņi apstājās timeout, vai ir kāds ērtāks veids kā uzlikt uz phpmyadmin bz2 failu 270mb(uz lokālā)? Paldies. Quote Link to comment Share on other sites More sharing options...
briedis Posted September 23, 2009 Report Share Posted September 23, 2009 270mb caur webisku upload izklausās diezgan ārprātīgi... neiedziļinājos, bet noteikti var atrast googlē info pēc: phpmyadmin import large file Quote Link to comment Share on other sites More sharing options...
bz2 Posted September 23, 2009 Author Report Share Posted September 23, 2009 http://www.wanderings.net/notebook/Main/HowToImportLargeMySQLDataFiles Šis variants varētu būt labs, bet atarhivējot bz2 failu iznāk 1,6gb Quote Link to comment Share on other sites More sharing options...
Klez Posted September 23, 2009 Report Share Posted September 23, 2009 parātīgās variants ir to failu caur ftp uzkopēt uz servera un uz servera (ja nav shell) ar php izpildīt komandas. (atarhivēt un importēt) komanda varētu būt šāda: bzip2 -dc /var/megafails.sql.bz2 | mysql -u jūzeris -p'parole' Quote Link to comment Share on other sites More sharing options...
bz2 Posted September 23, 2009 Author Report Share Posted September 23, 2009 mysql -u [user] -p [password] -h [hostname] [databasename] <[file.sql] Lab esmu dabūjis virsū... Tagad jauna problēma... Vienā vietā column rāda tikai ķeburus: LdÂ_u¶ß8ÕîLoÕyá=»tªêò~†€äËÞ«o Kā viņus dabūt vaļā? Quote Link to comment Share on other sites More sharing options...
Klez Posted September 24, 2009 Report Share Posted September 24, 2009 kādā formātā ir dati ? utf8 ? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.