vb 5.2 to vb 5,10

[DemOnstar]

My cpanel looks like this. . .



You will find php MyAdmin on there and MySQL Databases.
To copy your database go to phpMyAdmin, select your databse from the pane on the right. You will see its name. Click on it and you will get a page that looks similar to this..



At the top you can see OPERATIONS.. Click on that..



Where it says 'copy database to' give your new database a name and click GO

Or as an alternative, instead of choosing OPERATIONS, you could choose EXPORT and do it that way instead.

[Hectorsky]

So just to be sure. I will make database backup now , than I will install new version of soft , and it will be clean forum , after I will need to delete all tables on new database and to import old one yea? But I will need to do again upgrade for that and it can be same issue ,.

--------------- Added [DATE]1453304770[/DATE] at [TIME]1453304770[/TIME] ---------------

I think it won't work, because I will make backup of trash database , so when I will do importing of old database it will request to do upgrade ,and I can have same issue.

[DemOnstar]

Originally Posted by faustvasea97

So just to be sure. I will make database backup now , than I will install new version of soft , and it will be clean forum , after I will need to delete all tables on new database and to import old one yea? But I will need to do again upgrade for that and it can be same issue ,.

1. Make back up yes. You should do this before any upgrade or before you test anything or do anything. Your database will hold everything you have done.

2. Create a new database, it should have the same name and username details as you have put in your config.php.

3. Run the install like you did when you made your first successful attempt.
http://yoursite/core/install/install.php or whatever.
Let the install do it's job. You might remember the page that tells you to remove the install folder before you go to admincp. Do that.

4. When complete, go to the database that has been newly created and delete all tables.

5. Then go to the IMPORT feature at the top of the page and import the database you safely copied and downloaded. Import it to the database you have deleted all tables from.

6. It might also be an idea to test the copied database for anything else?

From memory, this is the way I would do it. Make sure your config.php reflects the names and paswords etc. . . . .

If it fails, you have still achieved in learning how to do the most important maintenance task ever.
Copying your database for backup purposes.

Good luck..

--------------- Added [DATE]1453305632[/DATE] at [TIME]1453305632[/TIME] ---------------

If your database is trash then you have nothing to lose.
Just do the install and begin again with your newly gained advantage. . .

[Hectorsky]

Originally Posted by DemOnstar

1. Make back up yes. You should do this before any upgrade or before you test anything or do anything. Your database will hold everything you have done.

2. Create a new database, it should have the same name and username details as you have put in your config.php.

3. Run the install like you did when you made your first successful attempt.
http://yoursite/core/install/install.php or whatever.
Let the install do it's job. You might remember the page that tells you to remove the install folder before you go to admincp. Do that.

4. When complete, go to the database that has been newly created and delete all tables.

5. Then go to the IMPORT feature at the top of the page and import the database you safely copied and downloaded. Import it to the database you have deleted all tables from.

6. It might also be an idea to test the copied database for anything else?

From memory, this is the way I would do it. Make sure your config.php reflects the names and paswords etc. . . . .

If it fails, you have still achieved in learning how to do the most important maintenance task ever.
Copying your database for backup purposes.

Good luck..

--------------- Added [DATE]1453305632[/DATE] at [TIME]1453305632[/TIME] ---------------

If your database is trash then you have nothing to lose.
Just do the install and begin again with your newly gained advantage. . .

Yes , but I don't wanna lose data from my database...

[DemOnstar]

Originally Posted by faustvasea97

Yes , but I don't wanna lose data from my database...

But that is the whole point and why you are copying it!!! You are copying it so you don't lose it.
Then you say it is trash. So why copy trash?

[Hectorsky]

BTW , how I can remove table's from new database?

--------------- Added [DATE]1453306903[/DATE] at [TIME]1453306903[/TIME] ---------------

So in case if your suggestion doesn't work ,vbulletin supporting team , can restore everything and to fix that issue ?

[DemOnstar]

Originally Posted by faustvasea97

BTW , how I can remove table's from new database?

Scroll to the bottom of the table page. Click 'Check All' and select drop.

Originally Posted by faustvasea97

So in case if your suggestion doesn't work ,vbulletin supporting team , can restore everything and to fix that issue ?

They will hardly be able to fix your database or be willing to do that. .

[Hectorsky]

I will try to do that in couple of hours, I will answer here in both case if it was successfully or not . Thanks for help. Hope it will work.

[DemOnstar]

Originally Posted by faustvasea97

I will try to do that in couple of hours, I will answer here in both case if it was successfully or not . Thanks for help. Hope it will work.

Make sure you have a copy of your original database before doing anything. Whether it is trashed or not, get used to making database backups. They should be done regularly as a routine.

Never attempt to install mods or script edits until you have a copy of your database to fall back on.

[Hectorsky]

Originally Posted by DemOnstar

Make sure you have a copy of your original database before doing anything. Whether it is trashed or not, get used to making database backups. They should be done regularly as a routine.

Never attempt to install mods or script edits until you have a copy of your database to fall back on.

Step 1 - Connection successful
Table Conflict
Creating access table
An error has occurred with your database. Please contact vBulletin Support for assistance.

Module: install, Step 2 Database Error:1050

Table 'access' already exists

Query:

CREATE TABLE access (
userid INT UNSIGNED NOT NULL DEFAULT '0',
nodeid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY userid (userid, nodeid)
) ENGINE = InnoDB