Cant connect to database error - I like to restore on the same site | Wordpress Support | Forum Archive

The free forums are no longer in use. It remains available as read-only archive.

Avatar
Lost password?
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
The forums are currently locked and only available for read only access
sp_Feed Topic RSSsp_TopicIcon
Cant connect to database error - I like to restore on the same site
May 25, 2012
5:24 pm
Avatar
Guest
Guests

I have a multisite installation and one subdomain delivers this erro when clicking on a link.

All the instructions are for moving the DB to a new location. I just like to restore.

There is no simpler way to restore the DB I assume?

 

Thanks for any hints how I could fix the problem.

May 25, 2012
8:19 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

The restore process is the same for all hosts, including the original one. Make sure the mysql details you are providing there are correct; if you like to use phpmyadmin, the mysql backup is in the administrator/backups/database-sql.sql file inside the archive...

May 26, 2012
8:38 am
Avatar
Guest
Guests

Thanks for the reply!

There are 3 tables missing in the DB. I wanted to export/import them since the other sites are running and I am afraid that I will screw up completely when I restore.

I downloaded the .tar but cant expand it. Then I tried to restore on xampp/localhost to export the tables, but I cant figure out the ftp server name.  

I am happy to buy the one month support if you can fix it for me.

May 26, 2012
8:50 am
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

To untar the backup archive, it would be best to use an archive client like http://www.7-zip.org/ . Then simply restore the mysql backup to an empty database and use that data as needed.

 

And sure, i can help you with the task if you like. Ovidiu

May 26, 2012
9:11 am
Avatar
Guest
Guests

Ok, I made the payment. How to proceed?

I cant expand the .tar because its corrupted. I try to download again but have a very slow connection here in SA. The tar is 565 MB.

 

Thanks

Reinhard

I am using Mac OSX 10.6.3

May 28, 2012
7:41 am
Avatar
Guest
Guests

I solved the DB problem.

Now I try to get the backup running on localhost/xampp. I imported the .sql into a fresh DB, but cant get the domain right.

When I try to call it, I get
"This webpage has a redirect loop".

Any suggestions?

Thanks!

May 28, 2012
12:03 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Did you updated the WP wp-config.php details? Also, since you are changing the domain name, you should also implement one of the these changes http://codex.wordpre.....e_Site_URL

 

Ovidiu

May 28, 2012
2:05 pm
Avatar
Guest
Guests

Its a multisite and they say all these measures work only with single sites. I had changed the database entries with a search&replace plugin and the wp-config, except for these:

 

define('AUTH_KEY',         '[email protected]{%gQEpSr_+<dyb+>:Yd#nWbetyh~4rmMUap4Q6rZEcZy');

define('SECURE_AUTH_KEY',  xyz_wDSirinaafrica.comG<K?#S8{H>//EaLy7]h:jhRfj.K=Usg#g&$9+ox');

define('LOGGED_IN_KEY',    xyz{BZ2yHK_sbOo1@?!irinaafrica.com}H<`PM%7^l6VJTY,~DSOJ,zCtVI@Ym$WZi1@5x5');

define('NONCE_KEY',        xyz#l~ %RE`AZ/pirinaafrica.comUzn<&<R%71t-|[H-L+}AtN9/thH&dMcVM8WN|Q}');

define('AUTH_SALT',        'xy_*irinaafrica.comzG,jcuq2l=7l#KE[-1c)QW3a{LwGi-kwhRVP&]g');

define('SECURE_AUTH_SALT', ';xy:YOa*h[]-T&Diirinaafrica.comnp=:iQ;z$>OkEYNi2@Y`|5-c|n:Jb #}97E?LX7');

define('LOGGED_IN_SALT',   'xy((L%LEcHKlirinaafrica.com[IaA9<bDvi`h/M:3U7xK8S]A|.Q,2$|*jcOqWNB');

define('NONCE_SALT',       'xy)497^JDbe-)irinaafrica.comG:*}/Prup?HeQMLNLz2kG~d/306X7Noin@gGh7+');

 

Must I change the domain names here as well?

 

With the loop error page I end up with this url in the browser:

http://localhost/iaf.....=localhost

May 29, 2012
5:59 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

You might want to check for help on the WP main forums, you might have better luck with somebody more experienced with WPMU transfers...

Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
mlguru: 30
Django29: 29
D: 21
Andy: 21
Marcus: 20
Jamie F: 19
Member Stats:
Guest Posters: 738
Members: 10052
Moderators: 2
Admins: 3
Forum Stats:
Groups: 3
Forums: 7
Topics: 2397
Posts: 8236
Newest Members:
piotr K
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0