Kryptronic Software Support Forum
You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
#1 09-13-2018 10:27:05
- webbytech
- Member
- Registered: 09-12-2018
- Posts: 10
Migrate Webhosting
Hi All,
I have read many posts on migrating, seems pretty straight forward.. More guides if you have them would be great.
Few questions on the database, which again I have found a few discussions on.... core_sessions, mine seems to contain over 500,000 rows, giving me a 310meg table, along with 2 other tables xbak98k1_core_sessions and xbak3m0q_core_sessions which I assume are just backups. Can I really clean this table? what does it store? Can we also NOT export the xbak* tables?
Thanks in Advanced, much appreciated.
Offline
#2 09-14-2018 07:40:09
Re: Migrate Webhosting
Hey there. You can clean the database in the fashion you're looking to. I'd recommend doing this:
- Drop every table prefixed with 'xbak'. They are backup tables you created at some point and are not needed.
- Run these SQL statements against the database to clear sessions and associated data to really drop the weight of the database (also removes backup references):
DELETE FROM core_sessions
DELETE FROM ecom_cart
UPDATE core_users SET lastsid=''
DELETE FROM core_dbbackup
This should really shrink the database and make it easy to transport by dumping it to a file:
mysqldump -h localhost -u USERNAME --password='PASSWORD' DATABASE > backup.sql
And to restore it on the new server:
mysql -h localhost -u USERNAME --password='PASSWORD' DATABASE < backup.sql
Nick Hendler
Offline
#3 09-14-2018 12:17:51
- webbytech
- Member
- Registered: 09-12-2018
- Posts: 10
Re: Migrate Webhosting
This is superb, I will give it a go and return with the outcome 
Thanks very much.
Offline
#4 09-23-2018 12:03:45
- webbytech
- Member
- Registered: 09-12-2018
- Posts: 10
Re: Migrate Webhosting
Move everything now we get a blank page... nothing loading, white page.
Offline
#5 09-23-2018 12:23:59
- webbytech
- Member
- Registered: 09-12-2018
- Posts: 10
Re: Migrate Webhosting
Looks like Database connection issue
An error was encountered while creating a new CORE object. Error Information: The core constructor function was accessed during initialization by an Installer interface with a password, however the password supplied could not be validated.
Password tested and working!
Offline
#6 09-23-2018 13:14:36
- webbytech
- Member
- Registered: 09-12-2018
- Posts: 10
Re: Migrate Webhosting
Deleted both config files and setup again, importing SQL data at the end... All now working
Offline
#8 09-28-2018 07:23:03
- webbytech
- Member
- Registered: 09-12-2018
- Posts: 10
Re: Migrate Webhosting
webmaster wrote:
Glad you worked it out. Sounds like MySQL db info changed, so you could have run the installer and just updated that. But you're good to go now, so that's what counts.
Yeah the issue was during the installer, it would not accept the new DB credentials, I thought it may have been permissions on the files, but all the other settings were getting saved to the config.php files apart from the SQL details.
So I thought, let's start the config files again...
Offline
#9 09-28-2018 07:26:35
- webbytech
- Member
- Registered: 09-12-2018
- Posts: 10
Re: Migrate Webhosting
Hi,
Looking at the old a new sites both state in checkout "Enter Payment Information" which goes straight through to world pay and not give any other options that are enabled in our "Processing Gateways". Is there anywhere else that this can be configured from?
We are sure we had this enabled before, and have only now coincidently noticed it different.
Please advise.
Offline
#11 09-28-2018 12:01:07
- webbytech
- Member
- Registered: 09-12-2018
- Posts: 10
Re: Migrate Webhosting
webmaster wrote:
That's all configured using Store / Commerce / Processing Gateways.
Hi Nick,
Yes, we have 2 enabled but it still only show 1 and the test does not relate to what we have inputted in the test fields.
Offline