move database to a new install

I have created a fresh install for a cart as I believe with so many themes and extensions installed and uninstalled that along the way things have got a bit corrupted.

I tried using the phpmyadmin to export the database then import the database data to the new install.
A bunch of errors came up which I suspect is due to several extensions changing things within the database?

With that in mind is it possible to just download the customer data such as names, passwords etc as well as categories and product data?

You don't have to export/import your Database, you could just create a NEW Database, and then, copy/paste the content of your existing database into the new one, by use of your Server MyPHP DB Admin Tool. Then, you have a full and complete errorfree new DB! Should be done anyway, from time to time, just to make sure....
Ernie

thanks for taking the time to reply.

One issue I have is that the hosting is cluster hosting so each database created is done on a randomly generated server.
so for example the server with old shop would be 123.87.87 and new site would be 123.88.88 as the host.
this then throws an error up that I do not have permissions to create a new database if I try and do it through phpmyadmin.

My other concern is that over the years changes may have happened to the database by various extensions that have been installed and removed.

does anyone know if its possible to just move the customer data, categories and product data across to a new database?

The problem is, that you HAVE TO make sure, to have a completely generated DB, by just setting up a new DB, you have no required OC-Tables generated yet, so, you need to INSTALL a virgin Shop, fully, in any case, and then, you could export/re-import some of your content into the new DB.
Ernie

I did make a virgin install with no changes other than the theme and vqmod.
trouble is when I export the old database and import it to the new shop it comes up with loads of errors and stops me fully importing it.

I believe that's because changes have been made to the database structure in some way by an extension.
If I just export customer details, categories and products is this possible?

I know I can use import/export xls to bring in the product data but that would leave customer data missing.
Would be great if I could easily do it all from phpmyadmin

the whole reason I'm looking to do this by the way is due to slow page load times.
For some reason server response time is 5+ seconds and page load times seem slow.

well, if you care to link your Site, I am a 'free' experienced Top Tuner, when it comes to this on v.1.5.6.x
Just check the link below, to see, what's possible without expensive Mod's or big work.
Ernie

oh thanks
its https://wwwfiresidefabrics.co.uk/quilting-fabric

Its running page speed and seo mega kit plus.

I thought maybe at first it was the template.
Its running journal theme from themeforest. The theme makers say nothing is wrong with the template.
So maybe its the sheer volume of products on the site? but even so im unsure why it should run so slowly.

well, Journal uses it's own Mod's, and Ways, so, I never bothered with this way of doing things. It's much to screwy, and different from anything else, to really waste my time on such. In addition, you have/use a lot of GIZMO's too, producing DNS lookups, and other THINGS, just slowing down your site considerably. To be honest, it's one of the worst Sites, I ever tested, especially on Google, performance-wise, and I am not even trying to make you feel bad.

But it has nothing to do with the Quantity of products, I tested my Sites with up to 24K of Products, and it did not make a big difference.

Therefore, by use of 'regular' Techniques, it could even produce worse results. Still, there are some Things, wich could be made better, like remote-site image-linking, image-tagging, and doing some tuning in the .htaccess file, e.t.c., but as I said, it would take a lot of time, just to find out, without colliding with existing 'Stuff'.

https://tools.pingdom.com/#!/NgYEA/http ... bric-rolls
https://gtmetrix.com/reports/www.firesi ... k/veheGbv6
https://www.webpagetest.org/result/161101_4R_JYJ/
https://developers.google.com/speed/pag ... tab=mobile

Sorry for the bad News!
Ernie

Its a lot worse since I cleared the cache.
Im my own worst enemy sometimes.
I had the site at 74/100 and thought maybe the various extensions were colliding with journals own.
I enabled journals cache which dropped it down to 19/20
I then removed the page speed extension and cleared cache, then enabled the journal system again.

Page speed has increased slightly from 10s to 6.9s but google pagespeed still says 20/100 as for some reason it says compression is not enabled.

I have compression enabled at 9 in system and also in htaccess

gtmetrix now gives a much better result with 63% pagespeed and 78% yslow.
Its annoying as I had this site at 94/100 before we made the massive upgrade to a nice template etc.

I just don't understand why the pages themselves take so long to load... its like they are pre loading absolutely everything in the site before showing any of the pages.

ok well found a conflict from various settings.
Spent a bit of time turning on and off relevant extensions and now have pagespeed at 83/100
I don't see how this can be improved as all the things it has marked me down for I cannot change.

Gtmetrix also gives me 85% and 83%