jumpingrightin asked:


How do you backup and restore a MySQL database on a Linux system without using the plain dump?
“Just copy the whole data folder of MySQL”

What is the Linux path to this?

Kizzeith asked:


I want to be able to enter info into a MySql db via a php form (I know how to do that.) When it’s entered, I want to have a URL generated automatically that the record (entered) can be viewed from…

Does that make sense? Does PHP have a function for this?

hawkal2k5 asked:


I have a table in a database with about 2000 entries and 3 of the field in the database of all these entries need to be reset to their original value. How could I do this without manually going through all 2000 values and editing them?
I need to reset them to their default values which is just “blank” no value also its only for 3 field in the table not the whole table

J Computer Repairs. asked:


How would I make a webpage where you enter your character name and click add and it adds a number to a field in the database of that character name, and this can only be done once every 12 hours.

Indian asked:


Our college is telling us to use VB with Oracle. But I want to use Mysql as database back end. Will it be effective? Please give me the details how it should be done? Thanks in advance!

Robin P asked:


I have a MySQL database with the first column containing id numbers. How would I “SELECT” the row containing id 58 for example?

Bert P asked:


I have a MySQL database and a website. I want to create a form to log in, whereby then users can add to the database, and also view the stored information in a table.

Is there a PHP template I could use? Writing it by myself seems like a colossal task.

Thankyou

reuben asked:


Is it possible to have your MYSQL database in a server different to the one that hosts your website? i.e., database in different hosting company/server . Or do both website and database have to been on the same server for the website to use the database??

ken asked:


Is there a program that will convert any excel spreadsheet into mysql. I don’t want a program that has to connect to the database from my computer, but more like a converter that will change the data of the spreadsheet to text like: “INSERT INTO `table` VALUES (”") etc…” Any ideas? thanks.
My website host does not allow remote connection to their databases.

winkelthorp asked:


Normally line breaks in code are “\n” but how are they stored in a MySQL database? I need to take them out so that I can properly display some content. No, I do not mean a “
” I mean a line break in the CODE. Thx in advance!