Move to another webspace

From EQdkp Plus Wiki

To move your EQDKP Plus on another webspace, you need to follow the steps in this article. Overall, this is not recommended for the average user, as so many things can go wrong in the SQL. Your webhost might support moving the SQL data for you. Moreover, there is no guarantee that you will not lose data.

1 Backup
- 1.1 Backup Files
- 1.2 Backup SQL Data
  - 1.2.1 SQL backup via phpMyAdmin
  - 1.2.2 SQL Backup a MySQL program
2 Upload your backup to the new Webspace
- 2.1 Upload Files
- 2.2 Upload SQL Data
  - 2.2.1 Upload via phpMyAdmin
  - 2.2.2 Upload via MySQL Program
3 Changing the configuration data for the new web
- 3.1 Config.php
- 3.2 _config Table

Backup

Backup Files

Using your favorite FTP program, download the complete folder for EQDKP and store it somewhere on your hard disk.

Backup SQL Data

To create a backup of your SQL data(including the user data, scores, raids, etc.) there are two paths:

PhpMyAdmin:
- Advantages: Is very easy for beginners to use.
- Disadvantages: Some servers may be special characters (ä, ö, ü, ß) will be lost.
Local MySQL client:
- Benefits: Guaranteed no special errors.
- Disadvantages: No free MySQL client is completely clean, there can always be mistakes, not recommended for a novice.

SQL backup via phpMyAdmin

Get on your phpMyAdmin (ask your web host if it is necessary for you to do this) and log in.
First, we ensure that the correct character set is used, so that no special characters are lost. Depending on the version you have on the main page, the following will appear:

Make sure this is set for you to display special characters.

Select your database from the left.
Click in the right part of the window on top of "Export" and leave all settings to default.
Make a check mark next to "Save as File" (at the bottom of the page) and then click on GO.
You'll get your complete data. Sql file to download. Save this file on your hard disk.
Opens the file with a text editor and search for special characters (ä, ö, ü, ß). If you do not find any, then you're unlucky and have to try with a different route than using phpMyAdmin.

SQL Backup a MySQL program

My personal recommendation is HeidiSQL, but of course also works with any MySQL client. (todo: This section through the MySQL command line tool (included failures) to replace)

After installing and starting the program you need to create a connection, click the "New" button, enter any name and then enter your server information (if you do not know, ask your provider).

Select your database from the left, then in the right you will see all the tables from your EQDKP (all begin with the same prefix, eg eqdkp1_ or dkp_ or eqdkp2_.Additionally, the table item_cache even !'). Select all the tables and right click to see the action menu, then select "Export tables as SQL".

Under "Selection" be sure that all your EQDKP Plus tables including item_cache are selected. Under "Options" you use settings as in the image above and select a file location/name and then click Export.

Upload your backup to the new Webspace

Upload Files

Using your favorite FTP program, upload the files you downloaded from your old webspace to the new one. You can also change the directory should you want to. For instance, if your old site was www.myoldsite/dkpsystem, and now you want www.mynewsite/eqdkp-plus. The settings you need to change will be discussed in Chapter 3.

Upload SQL Data

Upload via phpMyAdmin

Log on your new webspace in phpMyAdmin, select the database from the left and right click on Import. Then selects your SQL file you downloaded and click OK.

Now if you are hellbent and determined to use phpMyAdmin, and realize that you will have issues with special characters, you can go through the tables and replace them individually. However once again, this is not for the novice. But in the end it might be faster for the advanced user.

Upload via MySQL Program

Creat in your MySQL program a new SQL connection with the data of the new webspace (if in doubt, ask the provider). Connect and select your database in the left menu and click on "Import" -> "Load SQL file ...". Select your previously created. Sql file and click Open.

Unfortunately HeidiSQL is not in a position to make a flawless copy of the data to upload, so you have to make modifications:
Addition in the text box under "_plus_update" and delete the entire bracket behind it.
"INSERT INTO präfix_plus_update (name, version,` level `, changelog, release, download, realname) VALUES"
becomes
"INSERT INTO VALUES eqdkp1_plus_update" ...

Press F9, and then the import should go smoothly. If there are still errors, you know either MySQL can correct the error itself, or you must try it with phpMyAdmin.

If you are looking for a 100% clean solution, there is none. Perhaps your web host might provide you with the relocation of the SQL data to be helpful.

Changing the configuration data for the new web

Config.php

Using your FTP program open config.php from the root directory of EQDKP with a text editor. In this file, you will see the data for the MySQL server. Here you'll need to change all the entries for the new webspace. Leave the other settings alone !'< br> $ dbhost -> normal: localhost
$ dbname -> The name of the database, so you'll have in any case to the new name change.
$ dbuser -> The user name with which login to the DB, normal case: the same as $ dbname.
$ dbpass -> The password for the database.
$ ns -> Normal case: the same as $ dbhost.

Saves your changes and upload the file again to your new webspace high. This is the foundation that EQDKP uses on your webspace to connect to the new SQL database.

_config Table

Do you have your files in a directory different than on the old webspace, you need to check in the _config table two values:
server_name -> your server name, usually localhost
server_path -> your directory where EQDKP uploaded (if you've changed the directory, front and rear to the forward slash "/" careful!)

Move to another webspace - EQdkp Plus Wiki