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.
Hi guys,
Sorry to be posting again. I'm trying to recover my old cart data, created by SQL Express using the SQLite option in khxc/ccp. The data is stored in what appears to be a flat file called khxc.db but I'm simply unable to open it. I've tried multiple converters and an SQLite data recovery program. It's generally reported as 'not a database file' or 'not an SQLite file'. So I'm really a bit stuck.
I need to know if I'm right in thinking that the data is just stored in a flat file, like it would be in MS Access for instance, or whether there is more to it - as with MySQL. Is there any way I can get this data back? Or shall I save tearing my hair out and just tell my customers they all have to make new accounts? (not good for business).
I only really need the customers data back - I assume that would be a single table, I don't use products, categories etc, purely remoteadd from an existing website. Would it be possible in theory to set up a test installation using my old khxc.db, rip the appropriate table out of it and import it into raw admin?? Or would I be wasting my time with this also..?
Thanks for any help, I promise once this is sorted I'll be quiet again for a couple of months ;-)
RobH
Offline
Can you get ccp to access the old SQlite database? You could just do an export for that or any other database table from ccp into a csv file for which you would be able to import it into ccp when using MySql.
John
Offline
That was kind of what I was hoping. I've been looking at the KHXC -> Database connections etc.. Manage alternate RDBMS connections option - is this what your referring to John? When trying to do this it attempts to set up it's own database named D:/khxc-private/sqlite/6n31962i.db but I then get an error:
There was an error making a connection using the parameters submitted. The error returned was:
The sqlite PHP extension is not loaded. This script requires the sqlite PHP extension to be loaded in order to connect to the database requested. The KHXC_DB class attempted to load the extension at runtime, however the current server configuration did not permit the class to make this runtime change. Contact your server administrator and request that the sqlite PHP extension be loaded at runtime.
I was having a similar issue with cURL when trying to get the install to run using MySQL, resolved by copying a load of .dlls and php.ini files to a number of different folders. Problem is I don't see a php.ini extension option for sqlite, only mssql and that's already uncommented :-\. I don't understand why it won't load - obviously it worked previously or I wouldn't have been using it with khxc! I guess it's possible I overwrote the php.ini that was working for sqlite but unlikely.
Cheers
RobH
Offline
Well that seemed to go rather well. Created an alternative RDBMS connection and renamed my existing khxc.db file to replace the db that it automatically created, switched to the alternate connection and hey presto! Exported all my customers and imported them back in after changing to the primary connection.
Thanks for your help.
RobH
Offline