Mysql & Mymail

[me-writer]

I set up a MySQL database to use with PHPlist, but found the script too difficult to work with so I installed MyMail. When configuring the script, I used the same database. However, in testing I've discovered some features aren't working (e.g., validate subscriptions). Should I have created a new database to use with the MyMail script?

 

I'm not familiar with how MySQL works, but I did notice when I went into phpMyAdmin that PHPlist files are the only ones shown. This is what made me think I needed to create a new database for the MyMail script.

 

Help?

 

Thanks!

[TCH-Don]

The table structure may be different for the new script.

I would follow the install instructions.

 

Then be sure that in MySql you

 

1 - created the new database

2 - created a user

3 -added the user to the database

 

 

Then to connect to the database in a script use:

 

host: localhost

database: yourCpanelName_databaseName

user: yourCpanelName_databaseUser

password: mypassword

 

Do not try to use phpmyadmin to create the database.

But use it to add the tables to the database.

The script should have a sql file to create the tables

by using the sql tab ans browsing to the file on your computer

or copy and paste the text from the table file inti the text query window.

[TCH-Don]

You also may want to look at http://tincan.co.uk/phplist

phplist, its looks earier to use

[me-writer]

Actually, I don't agree that phpList is easier to use. I started out with it and couldn't figure out half of what I was supposed to do. That's why I switched to MyMail. It's also free -- and much more user-friendly.

 

Re: the database -- you've sorta answered my question, but not really.

 

I think I'm just going to have to do more research and play with the script a bit more.

 

Thanks anyway!

[TCH-Don]

Glad to help.

 

I just tried phplist and thought it was better than others.

I will take a look at MyMail too, thanks.