مش کل در اجرای کوئری

من باید یک سری کوئری اجرا کنم این کوئری ها به شرح زیر اجرا کنم We've ...

موضوع مش کل در اجرای کوئری,.

خدمات پشتیبانی ویبولتین 4, وی بی پرو, ویبولتین

تاريخ ارسال:2014/07/20

هاست سنتر من باید یک سری کوئری اجرا کنم این کوئری ها به شرح زیر اجرا کنم We've just successfully migrated a 6m post VB forum cross server and charset and as I spent a fair amount of time working this out I thought I'd share. There are apparently third party tools to do this but I've read mixed reviews about them. I found a good step by step on the charset changeover here ( though there are some errors in what he's done. To manually make the transition on a linux box, you'll need shell access and here's what needs to be done... Shut-off forums in admin panel.Shell into your box and dump all the mysql data minus binary image data Code: کد: # mysqldump -u DBUSERNAME -p --opt --skip-set-charset --ignore-table=VBULLETINDBNAME.customavatar --ignore-table=VBULLETINDBNAME.customprofilepic --ignore-table=VBULLETINDBNAME.picture --ignore-table=VBULLETINDBNAME.socialgroupicon --ignore-table=VBULLETINDBNAME.socialgrouppicture VBULLETINDBNAME > VBULLETINDBNAME.sql Dump the image data Code: کد: #mysqldump -u DBUSERNAME -p --opt --default-character-set=latin1 VBULLETINDBNAME customavatar customprofilepic picture sigpic socialgroupicon socialgrouppicture > VBULLETINDBNAME_images.sql Convert all the characters in the data dump to UTF8 via iconv Code: کد: #iconv -c -f windows-1251 -t utf-8 VBULLETINDBNAME.sql > VBULLETINDBNAME_utf8.sql Change the import script to make sure it imports as UTF8 Code: کد: #sed –i 's/latin1/utf8/g' VBULLETINDBNAME_utf8.sql #sed –i 's/latin1/utf8/g' vogue_forums_untouchable_images.sql Create your new database on the second server *Obviously make sure your new database is setup with UTF8 as the default collation* Import your converted dump into the db you just created. Code: کد: #mysql -u NEWDBUSER -p –default-character-set=utf8 NEWVBDATABASENAME < VBULLETINDBNAME_utf8.sql #mysql -u NEWDBUSER -p –default-character-set=utf8 NEWVBDATABASENAME < VBULLETINDBNAME_images.sql Now if you've changed domains you'll need to update the settings tables... you can get away with the following - there's two db values you need to change first one is pretty simple: Code: کد: mysql> UPDATE setting set value = 'http://YOURNEWDOMAIN' where varname = 'bburl' The second update is stored as a serilaized value in the datastore table so you need to do a bit of work to get the right return value: First grab the data you need to change from the old DB Code: کد: mysql>select data from VBULLETINDBNAME.datastore where title = 'options' Grab the returning value and throw it in the following php (once you've changed the your new domain bits) script.. then grab the output: PHP Code: کد: #MYSQL: select data from VBULLETINDBNAME.datastore where title = 'options' $the_object = 'PUT RESULT OF ABOVE MYSQL QUERY'; $the_object = unserialize($the_object); $the_object['homeurl'] = 'http://YOUR NEW DOMAIN'; $the_object['bburl'] = 'http://YOURNEWDOMAIN'; $the_object['cookie_domain'] = 'YOURNEWDOMAIN'; echo serialize($the_object); Update the datastore table with the output from the above script Code: کد: mylsql> UPDATE datastore set data = 'OUTPUT FROM ABOVE - ESCAPE THE SINGLE QUOTES ETC' where title = 'options'; Load up a clean vbulletin latest release in a new vhost on second server change the /includes/config.php on the new install to reflect the new environment run through the vbulletin upgrade process at (disregard warning about wrong version) Update thread counters (admin -> maintenance -> update counters -> thread then post) Go to admin panel -> address all issues. (if any hang, log out and in again and they will be shown again for you to run) If you can't login: Upload the DO_NOT_UPLOAD folder and reset the cookie_domain using the script If forum not displaying use the tools (and you've updated thread counts etc in admin/maintenance) reset the caches using the tools.php page update the default character set (Admin CP -> Languages & Phrases -> Language Manager -> [Edit Settings] -> HTML Character Set) change ISO-8991 to UTF8 delete the DO_NOT_UPLOAD folder from your server delete the install directory from server ولی تو اولین کوئری پیغام خطا مواجه می شوم MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -u DBUSERNAME -p --opt --skip-set-charset --ignore-table=VBULLETINDBNA' at line 1 هاست,دامین,سایت,وب,طراحی

مش, کل, در, اجرای, کوئری

مش کل در اجرای کوئری

میزبانی وب ,هاست,فضای وب,ویندوز,لینوکس,دات نت,پی اچ پی,web hosting,windows host,linux host,,php,sql server,mysql میزبان پایتخت ارائه دهنده خدمات میزبانی وب، هاست و هاستینگ، میزبانی هاست، دامین، میزبانی نمایندگی، نمایندگی وب، سرور مجازی و سرور مجازی ابری می باشد.هاست,میزبانی وب,دامین,سرور مجازی,میزبان پایتخت,host,domain,vps,mizban paytakht,hosting,share hosting,میزبان وب,میزبانی هاست,هاستینگ