Views in PHpmyadmin
Posted: 11. November 2010 23:34
I created a site some years ago initially using Access and ASP, and when I switched to PHP I dowloaded and installed all components seperately (mysql, apache and phpmyadmin).
The web site uses 8 tables and an updatable query or view. The view is used to update the site via a home made cms system that I wrote, and still works fine today.
I needed to set up a different computer, and switch to the latest stable versions of PHP and MSQL. This time I use Xamp for windows verion 1.7.3 to do the setup.
I then downloaded the site pages and a database dump from the distant server, complete with data and structure.
The pages no longer work because for some reason, the view has not been imported along with the tables.
All the data for the 8 tables is there, but without the view, I cannot run the site locally without a total rewrite and risk of losing some of the 3200 records, nor can I update the database with the cms system.
Does the Xampp system support views, or do I have to make changes to ini files or add extensions in order to use them? Or does a dump not include them?
I do have the original query that created the view, but I cannot work out how to re-create it using phpmyadmin, despite reading the instructions in the help file.
Can anyone help?
The web site uses 8 tables and an updatable query or view. The view is used to update the site via a home made cms system that I wrote, and still works fine today.
I needed to set up a different computer, and switch to the latest stable versions of PHP and MSQL. This time I use Xamp for windows verion 1.7.3 to do the setup.
I then downloaded the site pages and a database dump from the distant server, complete with data and structure.
The pages no longer work because for some reason, the view has not been imported along with the tables.
All the data for the 8 tables is there, but without the view, I cannot run the site locally without a total rewrite and risk of losing some of the 3200 records, nor can I update the database with the cms system.
Does the Xampp system support views, or do I have to make changes to ini files or add extensions in order to use them? Or does a dump not include them?
I do have the original query that created the view, but I cannot work out how to re-create it using phpmyadmin, despite reading the instructions in the help file.
Can anyone help?