Export data from the database

Hi,

You can use the export button of your PHPMyAdmin on the hikashop tables.
That will give you a txt file with MySQL queries in it.
Then, you can use notepad++ to open the file on your local computer and search and replace the old table prefix to the new one.
Then, if you already have the hikashop tables in your new website database, rename them, and import the file with the prefixes updated.
It should be able to handle big files provided the max_execution_time and memory_limit of your php.ini are high enough.
Otherwise, if you're on your own server and you have a SSH access, you can use putty to connect to the ssh and run mysqldump / mysqlimport :
dev.mysql.com/doc/refman/8.0/en/mysqldump.html
dev.mysql.com/doc/refman/8.0/en/mysqlimport.html
The PHPMyAdmin interface actually use these in the background but it is limited by PHP while if you run these directly in the command line, you don't have these restrictions.