Export and import PHPmyadmin

PHP
1

I want to export a DB from one version of PHPmyadmin and import the DB into my local version so I can work with it.

I am a bit confused about the best way to do it?

Is export as a csv best?

The DB is large with 31 tables total: 132MiB

Thanks for any help :slight_smile:

2

PHPMyAdmin isn’t really the best tool for this job, do you have CLI access? If so, you can use mysqldump to create an easily importable .sql file.

3

No I don’t at the minute I am brand new to PHP in the last few days, Good knowledge of HTML and css but very little programming knowledge. I do understand the principles just about though :slight_smile:

I have managed to do it with Myadmin now with an SQL export.

Thanks for the super quick answer.