By Fergal on

Hi,

I wonder if anyone can help me, maybe there's something obvious I'm doing wrong here.
I'm trying to create a backup site of my production site but get "No search term is specified" when trying to access backup site.

My drupal database is called drupal_prod.
My directory name is var/www-prod
My basr url is 'http://prodblog'

Using phpmyadmin I sucessfully exported my drupal database called "drupal_prod" to a gz file

In the exported sql file I modified all references of: drupal_prod to drupal_prod2
www-prod to www-prod2
www.prodblog to www.prodblog2

I created an new blank database called "drupal_prod2" and sucessfully imported
the export file into this new database - 116 tables now in each database.

I then copied my newtork files from var/www-prod to var/www-prod2
I Changed the settings.php in var/www-prod2/sites/default to
$db_url = 'mysqli://drupaluser:saturn999@localhost/drupal_prod2';
$base_url = 'http://prodblog2';

That's it - have I missed something obvious ?

Any help would be great - thanks in advance.

⋅ Categories: Drupal 6.x

Comments

Fergal’s picture

Fergal commented

Am I going about this the right way even ? Or are there easier options to create backups ?

WorldFallz’s picture

WorldFallz commented

I usually do:

truncate accesslog;
truncate cache;
truncate cache_contentr;
truncate cache_filter;
truncate cache_menu;
truncate cache_page;
truncate cache_views;
truncate watchdog;

Prior to making a backup... might be worth a shot. Also, you may want to try the http://drupal.org/project/backup_migrate module.

Fergal’s picture

Fergal commented

Thanks