Access database to mysql

You don’t want to do it taht way.

Best to make a new Database in MySQL.

I don’t know anything yet about howa mysqldatabase works, but are you saying that I won’t be able to copy and paste in formulas,etc that are withn dozens of queries within my cuirrent access database? Does mysql not use table,and queries?

Oh you can copy and paste them in, but WordPress won’t use the same code you have in access, so why are you trying to merge it that way?

Hi. As I am unfamiliar with mysql, it would probably be best for me to download it and get a jist of whether I need to re-create all of my formulas within each query, etc. Hard to ask questionas and probably for you to answer them without my at least having it in front of me. I am in the process of downloading a first step for running mysql. If you can give me any heads-up on that or other starting points , I would greatly appreciate it. Unfortunatley, my only exposure to databases has been through Access 2000, and mostly through using the frontpage database wizrd, which creates .asp pages. I am hoping the transition to whatever system is involved with Word Press will not be too complicated. I have between 200-300 .asp pages within my website, which more or less manage the back-end flow of my business (Combined Facilitation and fulfillment system for the sale of renovations and mortgage financing)

I am hoping (and praying) that I have not permanently boxed myself in with my limited scope of knowledge of 10-year old technology.

Ron

Not if you’re willing to learn ??

Access and MySQL are very different, though, and I really don’t get why you feel you need to move your content directly to MySQL. What kind of forumlas are we talking about here?

Really, if you want to use WP, install THAT. Look at how it runs, study the DB. Otherwise, you need to go find some database gurus to help you.

Hi:

I am trying to install mysql on my computer, which I am having some difficulty with. But to answer your question:

I hope that I have assumed correctly that a mysql database conists of tables containing fields and rows (records) and queries, which draw specific fields from one or more of those tables. In Access, when you are building a query that consists of number/currency-related fields, you can create a formula (simple or complex) within the query to add the values of two or more of those fields and display the result on the page you are creating. As I have never worked with any other databases than Access, and have relied on the Frontpage database wizard to build an .asp page to display & update fields within tables or queries of the connected database, is this a standard function of mysqlr in relation to how a Word Press Page is built?

a mysql database conists of tables containing fields and rows (records) and queries, which draw specific fields from one or more of those tables.

Yes.

And that’s when it starts getting really different.

For installing MySQL on your PC, take a look at https://www.apachefriends.org/en/xampp.html That will put SQL and PHP, and Apache, which is what you need to run WP locally.

In WordPress, all the queries are written (for the most part, you can add more, but that’s advanced stuff). There aren’t the same number/currency-related fields natively, though there may be via plugins.

I don’t know is this thread will help you any: https://www.access-programmers.co.uk/forums/showthread.php?t=190649