How to delete the old site without deleting the redirections

  • Resolved tovk

    (@tovk)


    7 years, 8 months ago

    Greetings,

    here’s my situation. I have successfully duplicated my site using the Duplicator plugin and migrated it to a new domain. However, the old site still exists and it’s files slow down the new site because both sites are located in the same database (I only have 1 database). After the migration I added a 301 redirection to the .htaccess file so all the traffic is now directed to the new site.

    Here’s my problem. I want to delete the content from the old site, but to keep all the specific redirections that exist at the moment (for example from post x that used to exist on the old site to post x on the new site and not from post x to new site’s front page). How can I achieve this? Which files and folders should I delete and which ones should I keep?

    All help is appreciated and I’ll happily provide more information if necessary. The old site is here and the new one is here.

Viewing 10 replies - 1 through 10 (of 10 total)

  • Hi @tovk,

    Typically the best solution is to create a new database and run the installer. This way the new site can be updated separately from the old site. If your trying share the same database its not an easy task to share the database without effecting the other site…

    Hope that helpps~

    Thread Starter tovk

    (@tovk)

    Greetings,

    thank you for the reply. As I have only 1 database what are my options then? I want to turn the old site into a one big redirect but remove all the other content that take space in the database. The two sites or domains have both their own folders in the database’s root folder. As I can’t log into the old site anymore I guess I have to delete the files via FTP? I’m just wondering which files to save and which ones to remove so that the redirections aren’t affected, and of course how to achieve this.

    Thank you for your time.

    If you only have one DB (which is pretty uncommon) and you have already setup the second site then you might try this plugin. As it updates URLs on a live site.
    https://www.ads-software.com/plugins/velvet-blues-update-urls/

    I’m not sure as to the degree to which it replaces all the data, so you may have to double check the results…

    Hope that helps~

    Thread Starter tovk

    (@tovk)

    Greetings,

    I don’t see how that plugin has to do anything with the problem I described. It seems that I will have to seek a solution elsewhere. I thank you for your time.

    No Problem… I don’t think there is really a solution with Duplicator for your issue, just throwing out some other ideas…

    Thread Starter tovk

    (@tovk)

    Greetings,

    I have managed to make some progress in this situation. I deleted everything in the domain’s directory via FTP (except the .htaccess file) and all the redirections are now intact and work correctly.

    However, there is still the database itself (which I access via phpMyadmin). I noticed that the databese looks quite messed up and doesn’t have the 11 defaul WP tables it should have. Why is this?

    There’s a total of 61 tables and all start with a prefix: “mod803_”. What does this mean? Does it have something to do with the fact that used the duplicator plugin to migrate a site inside one database?

    So what I am asking is this: Why are the database’s tables messed up and how can I restore them to the original condition? And is there now any duplicate content inside the database that I should delete?

    Getting there.

    When you build a package it creates the database.sql file. The routine uses either PHP or mysqldump based on the settings (Settings > Packages). If your database originally has 61 tables and some of them are not showing up inside of the database.sql file then there might be two items that may I can think of that would cause that to happen…

    Although I have never seen an issue where the tables don’t get created during the package build. Occasionally errors can happen at install time when if tables may have issues with the table collation types or server version compatibility issues, but as far as the database.sql not creating tables, never seen that so my best guess would be below:

    1. A filter was added to the database table filters (see step 1 when creating a package)
    2. The database user set in the wp-config.php doesn’t have enough permission to create a table via mysqldump or via the “SHOW CREATE” command.

    Those are the best guesses I have as that issue has never been presented since the plugin was made…

    Thread Starter tovk

    (@tovk)

    Thank you for the reply.

    I didn’t change the defaulf options when creating the package. Also the database user that is mentioned in the wp-config.php is the one and only admin account.

    What are my options?

    If you want to submit a help ticket I can take a look at your setup. Just referr to this thread…

    Thread Starter tovk

    (@tovk)

    Issue solved. Good support.

    Thank you.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘How to delete the old site without deleting the redirections’ is closed to new replies.