vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Transfer (https://vborg.vbsupport.ru/showthread.php?t=122330)

oninuva 07-27-2006 06:51 PM
Transfer
 
Is this how I transfer?

Upload /root files

Then Import database?

rogersnm 07-27-2006 07:54 PM
it would be a good start ;)

or import the database and then upload all the files, or do them both at the same time....

oninuva 07-27-2006 08:14 PM
I did that and it dosnt work. :(

Smiry Kin's 07-27-2006 09:03 PM
Quote:
Originally Posted by oninuva
I did that and it dosnt work. :(
dont see why not make sure your doing it right. e.g trying to connect to the right database... if you need any more help pm .e

Kirk Y 07-27-2006 09:46 PM
Could you be a little more descriptive and tell us what exactly isn't working?

oninuva 07-27-2006 10:54 PM
Well this is what I did.

I made a home backup from the old host.

I made a database backup from the old host.

I go onto the new host and upload the home backup. Takes like 2 hours.

I go onto the new host and upload the database backup.

I give the permissions to the new database.

Go onto the site. Error.

Does not send me a error message :(

Kirk Y 07-27-2006 10:56 PM
Click View -> Source Code/Page Source and you'll see the vB mySQL Error commented out: <!-- Error Stuff -->.

Have you changed your includes/config.php settings to reflect the Username/PW of your new mySQL DB?

oninuva 07-27-2006 10:58 PM
Yeah its the same. Or should be.... hmm

ok here is the error:

Code:

Invalid SQL:

                        SELECT title, data
                        FROM datastore
                        WHERE title IN ('','options','bitfields','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','userstats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue');

MySQL Error  : Table 'gamerzf_forum2.datastore' doesn't exist
Error Number : 1146
Date        : Thursday, July 27th 2006 @ 06:57:41 PM
Script      : http://www.gamerz-forum.com/forum/
Referrer    :
Username    :
Classname    : vb_database

Kirk Y 07-27-2006 11:08 PM
Do you have phpMyAdmin on your new server? Go take a look at your database with it -- from what I can ascertain from this error message, you're missing tables, meaning that your SQL was only partially restored or wasn't at all.

oninuva 07-27-2006 11:16 PM
Why would only half be restored? Should i try uploading it agian?

Kirk Y 07-27-2006 11:26 PM
If your tables are missing -- and they obviously are, I'd recommend it.

How big is your SQL backup?

oninuva 07-27-2006 11:28 PM
Ok my DB is about 6.8 mb When i restore through cpanel if it says
Restoring Database

Does that mean its done?

Kirk Y 07-27-2006 11:33 PM
-ing means ongoing or in the process of. -ed means finished or no longer processing. ;)

6.8 MB might be too big to restore through cPanel or phpMyAdmin. You might have to split it up into smaller chunks or restore via Shell/SSH.

oninuva 07-28-2006 12:18 AM
how do i split it up? into chunks

Mastar 07-28-2006 12:24 AM
The old DB might be corrupt

oninuva 07-28-2006 12:26 AM
No. Its brand new.

Guest210212002 07-28-2006 02:24 AM
You might need to edit config.php. You should just import via SSH.

And once again, please make more appropriate thread titles.

Kirk Y 07-28-2006 02:30 AM
To split it up, just open the .SQL file in a text editor like Notepad/Wordpad and cut and paste chunks of the code into seperate files, just be sure that wherever you cut out ends in a semicolon (;).

You could also use a staggered importer like BigDump.

Or as Chris said, if you've got Shell/SSH it'd be easier to import it using that. It's probably not enabled by default, so you'll have to ask your Webhost to enable it for you.

rogersnm 07-28-2006 07:07 AM
I set it up for him through big dump :)

Link is here: http://www.gamerz-forum.com/forum/

oninuva 07-28-2006 12:01 PM
Quote:
Originally Posted by acidburn0520
To split it up, just open the .SQL file in a text editor like Notepad/Wordpad and cut and paste chunks of the code into seperate files, just be sure that wherever you cut out ends in a semicolon (;).

You could also use a staggered importer like BigDump.

Or as Chris said, if you've got Shell/SSH it'd be easier to import it using that. It's probably not enabled by default, so you'll have to ask your Webhost to enable it for you.
So when i copy and paste the chunks out do I name the file the same as the DB?

Kirk Y 07-28-2006 04:49 PM
No you can name it whatever. Say you start from the top of the SQL file, cut out 1/3 of the file and then save it in a new file called SQL1, then do the remainder of the and save each file as SQL2, SQL3, and so on and so forth. Then in phpMyAdmin, use the import feature and import each SQL file consecutively.

But I think rogersnm set you up -- or something, if I'm understanding him correctly.

rogersnm 07-28-2006 07:25 PM
Yes, i have set him up. He didn't think i did. But now he has realised :)

oninuva 07-31-2006 12:02 AM
No I dont. How do you have my Cpanel and Stuff?

rogersnm 07-31-2006 06:00 AM
you told me it the other day when you were trying to import the databse the first time but cpanel wa buggered.


All times are GMT. The time now is 07:16 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01166 seconds
  • Memory Usage 1,754KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (24)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete