Convert phpList sql file to something I can open - mdb, xls?

Once you've installed phpList Version 2... ask questions here!
Forum rules
Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation. This is for Version 2 of phpList (the orange one).

Convert phpList sql file to something I can open - mdb, xls?

Postby denglund1996 » 4:04am, Tue 27 Feb, 2007

I used phpList to manage a contact database for my church. I closed the website site I housed it on, and all I have left is a database file with a ".sql" extension (e.g., database.sql). But I don't have anything to open this file to retrieve the data. Does someone know of a program I can use to open the file, or a program that will let me convert it to an ".xls" or something? Thanks.
denglund1996
phpLister
 
Posts: 7
Joined: 2:56am, Fri 18 Mar, 2005

Postby Dragonrider » 9:03pm, Tue 27 Feb, 2007

You should be able to open this in Notpad or similar, I usually do when examining my database .sql files
My sites:- http://wharfedalefestival.co.uk, http://ilkleygardeners.org.uk, http://emergencyaid.net, http://dragonrider.co.uk
Latest phpList version is now 3.0.12 (3 February 2015) and requires a minimum of MySQL 5.0 and PHP 5.3.x
Dragonrider
Moderator
 
Posts: 3460
Joined: 6:58am, Sun 02 Jul, 2006
Location: Ilkley, West Yorkshire, United Kingdom

Postby denglund1996 » 11:04pm, Tue 27 Feb, 2007

Yes, I can open it there. It's just that the data I want is surrounded by sql code. Not the easiest thing to extracate;-)

I was hoping to do something like I used to with phpMyAdmin where you tell the program to import sql and it makes all the tables and populates them for you. It would be much easier to export the data from a table than from this sql code mixture.

Thanks
denglund1996
phpLister
 
Posts: 7
Joined: 2:56am, Fri 18 Mar, 2005


Return to Question & Problems - after installing

Who is online

Users browsing this forum: Google [Bot] and 10 guests