i have a db in phpmyadmin having 3000000 records. i want to export this to another pc. now when i export this only 200000 entries exported into .sql file and that is also not imported on the other pc.
Answering this for anyone else who lands here. If you can only use phpMyAdmin because you do not have SSH access to the MySQL service or do not know how to use command line tools, then this might help. However as the comment above suggest, exporting a database of this size would be far easer with mysqldump.
phpMyAdmin (I'm using v3.5.6) allows tables to be exported individually like so:
phpMyAdmin also allows records to be exported individially or in groups, so you could for example, export just 10 records from a table with 100,000.
Hope that helps someone new to phpMyAdmin or DBA via the web.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With