Export doesn't work with Views

[Former user]

Originally reported on Google Code with ID 82

What steps will reproduce the problem?
1. Create a table of real data
2. Create a view from this data
3. Go to the view in the phpliteadmin screens, then select the Export tab

What is the expected output? What do you see instead?
I tried exporting as both SQL and CSV.  In either case, a small amount of header text
is produced, but no records are included.

What version of the product are you using? On what operating system?
V1.9.1 on Ubuntu 10.04

Please provide any additional information below.
If I try exporting from the table of real data, it works.

Reported by [e-mail] on 2012-01-14 18:15:14

[Christopher Kramer]

Thanks for submitting this bug report. Sorry for the late reply.

I could reproduce it, even in the latest development version.

I'll fix it soon.

Aside: If you export a whole db, you also don't get the views exported. Even if you
explicitly select them in the list of tables (where they appear).

Reported by crazy4chrissi on 2012-10-24 22:37:54 - Status changed: Accepted

[Christopher Kramer]

This issue was closed by revision r243.

Reported by crazy4chrissi on 2012-10-25 18:35:23 - Status changed: Fixed

[Christopher Kramer]

Just fixed this issue in revision #243.
When exporting a view as SQL, it only exports the CREATE VIEW statement.
If you want to include the data, you need to export the view along with the base table(s).

When exporting a view as csv, however, the current data of the view is being exported.

I guess that's how this feature is expected to work.

To try it, you can get the latest version from SVN:
http://phpliteadmin.googlecode.com/svn/source/1.9.3/phpliteadmin.php

Reported by crazy4chrissi on 2012-10-25 18:42:32