Robin P asked:


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.

thrashline posted video:

Beginning MySQL Shows you how to create,insert,update and delete databases/tables

technical asked:


I have installed Apache Server on my PC, with PHP and MySQL. But I store all my files and folders in Drive D:
While MySQL stores all its databases in C:\mysql\data. I want to change the drive from C to D?

alex asked:


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!