How to export/save ERD as PDF or as image in phpMyAdmin?

mysql phpmyadmin xampp erd
silver picture silver · Apr 20, 2015 · Viewed 16.7k times · Source

I have generated an ERD using the Designer in phpMyAdmin.

How do I save it as PDF or image?

On possible duplicate:

The "original" thread is referenced in the answer. This post is intended to be a visual tutorial thread with screenshots which the other thread does not have.

Answer

silver picture silver · Apr 20, 2015

To save as PDF:

1) Select databse.

enter image description here

2) More > Designer

enter image description here

3) Import/Export coordinates for relational schema enter image description here

enter image description here

enter image description here

4) Operations (scroll down) > Edit or export relational schema

enter image description here

enter image description here

Click Go.

5) Choose your preferences.

enter image description here

Click Go.

enter image description here

Save the file.

To save as image:

You can choose "SVG" in Step 5 instead of "PDF", but the it did not produce aesthetically desirable results for the ERD (at least for me).

I personally just converted the PDF to image using a third-party app.

Reference: phpmyadmin 3.4.0 ERD to PDF

Related questions

MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: NO)

I installed xampp,but when I tried to run it I got an error as thus: Error MySQL said: Documentation 1045 - Access denied for user 'root'@'localhost' (using password: NO) Connection for controluser as defined in your configuration failed. phpMyAdmin …

Read More
PHP: maximum execution time when importing .SQL data file

I am trying to import a large .sql data file using phpMyAdmin in XAMPP. However this is taking a lot of time and I keep getting: Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\dbi\…

Read More
phpmyadmin "no data received to import" error, how to fix?

I am using XAMPP on a pc atwork to host a database. I exported a backup ("bintra.sql") using phpmybackuppro. I use xampp on a mac at home, and when I try to import the sql file located on my …

Read More