Posts Tagged ‘databases’

I installed WampServer 2.0 (comes with recent versions of Apache, PHP, and MySQL) and every time I try to set up a password to protect my databases, I get blocked out. Can anyone give me a step by step of what they did in order to get a password on their databases?
Thanks!

I’m using OSX 10.6.2, a couple days ago I updated MySQL from v5.1.39 to the latest version (5.1.41) by installing the pkg file from the official website. After that the databases were missing, as if I never used MySQL. Even the users were reset.
I have a backup of the whole hard drive, how can I restore the databases?
Why did that happen?

MySQL database contains 2 tables: user table and text table (some news). The text is to be displayed on the web-site. Of course, I shouldn’t modify user’s data, but I need to update text that is in the database pretty often. Does it make sense to have two databases which I could donwload and upload separately or just one database with two tables for that purposes?
Thank you.

I am having a problem regarding the database that i should use in my program….. and i am confuse if i should use oracle or the mySQL data base please explain their different functions of these two databases?

Would it be difficult to use oracle or mySQL?

I don’t know much about php or sql yet and need to transfer a bunch of databases in a folder to the mysql database I made. I use godaddy for my hosting and there is no upload/import files option that I have found.

How do I change the MySQL directory to "use" a database on another hard drive? I can’t simply move the database to wherever the default root "mysql" and "test" databases are.

I just started exploring MySQL for a database that I want to set up. I want the online user to be able to search for any word in the entire database. The database might become 500 meg over time (small compared to facebook, big compared to a employee databse). At what point does searching that amount of a MySQL database going to be an issue? I am new to MySQL and databases, so any other help or suggestion regarding this topic is greatly appreciated.

I used "mysqldump -A" to copy some databases out and then "mysql" to import them back into another server. This works ok but all the user logins and privileges are lost. Is there an easy way to move the users and privileges?

Thanks!