aaron1948

Thanks.

1) RE: “Stay away from any ‘one-click’ install offered by hosts! They are bad. Do manual install.”

Conclusion?:
– APlus.Net (my host) offers WordPress. Install seemed more than “one click” — it had options.

– Question: Should I still uninstall and do manual install?

– Question: Re: Why is “one-click” bad. Can you direct me to information to read about why?

2) Version Issue

Conclusion?
Given the stats below — on local, I conclude I should revert to older MySQL to mirror live. Correct?

Live=
PHP Version: 4.4.4 (option for 5)
MySQL 4.1.22
phpMyAdmin 2.6.2-pl1

Local=
PHP Version: 5.2.3
MySQL client version: 5.0.37
phpMyAdmin – 2.10.1

RE: shorter texts. Thanks, I know. Am transitioning from print writer to web writer. Plus am creating major web portal with very large database, and wading thru “best practices.”

Thank you! I believe you ?? I’m in blog/MySQL learning mode.

So I conclude that it’s best if I construct any major db (with lots of information) outside of my Local MYSQL and then, working from Host, import as a CSV file.

(e.g., from Excel/Access/Open Office, etc. to a *.csv file — then, while on Host, import).

I suppose I could also build on MySQL local, export to *.csv file, and then import *.csv into MySQL?

I’ll read and research.

Make sensible?

Thanks for taking the time to advise. A couple of questions:

1. Data posts

RE: “There is no need to get involved in db transfers.”

One of my primary reasons for building locally is my need to compile a rather large db.

Seems easier to do and test offline first.

If db is names the same in both LOCAL and HOST, can I upload my LOCAL db and write over the HOST db, or should I just Import while logged on to HOST?

2. RE: Theme uploads

If I modify and tweak theme in LOCAL installation, I assume I just upload revised theme and copy over WP installed on Host.

BUT I’m confused about this:

In LOCAL installation, Worpress places several *.frm files in my local MYSQL directory at:

C:/wamp/mysql/data/mydatabasename/

Do I upload those *.frm files to HOST, where path is

HOST
/var/db/mysql/mydatabasename

Thanks.