Programming & Design

October 5, 2008

How do I import files from my computer to a remote MySql server?

mysql
Stefan asked:


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.

Filed under Programming & Design by administrator

Permalink Print 1 Comment

I use for bussiness application php and mysql and apache, Is it good idea?

mysql
mmadpetros asked:


I use for bussiness application php and mysql and apache, Is it good idea?

Filed under Programming & Design by administrator

Permalink Print 2 Comments

How do we calculate table row´s value in Mysql?

mysql
princeexpedition asked:


anybody would like to suggest me how can i calculate table row´s item values group by month in Mysql?

Actually, i have a table with some row´s item value. and i want to them group by month.

Filed under Programming & Design by administrator

Permalink Print 2 Comments

October 4, 2008

How to make MySQL to treat underscore as a wordseparator?

mysql
v.karailiev asked:


Accordingly to the MySQL documentation when I perform a fulltext search underscore and single quote are treated as a part of the word.
Is there any way to change this?

Filed under Programming & Design by administrator

Permalink Print 1 Comment

How can I get my Resin username and password to affect my mySQL database?

mysql
Doddzy asked:


I am a college student in a database class, and my team is working on a large security project for World Vision International’s new LEAP database. We are using Resin’s built-in functionality to monitor the login page on the site. However, there appears to be a default user for the mySQL database, as we cannot create a new user from the website even though the code is correct. It keeps saying that the default user lacks the permissions even if we log-in at the website (through Resin) with an account with the proper permissions. Can anyone shed some light on our problem? Thank you very much.

Filed under Programming & Design by administrator

Permalink Print 1 Comment

I have a mysql database on a usb stick. How can I put it on a mysql server without rebooting it?

mysql
jglw21 asked:


I have a mysql database on a usb stick. How can I put it on a mysql server without rebooting it?

Filed under Programming & Design by administrator

Permalink Print 2 Comments

October 3, 2008

How to use php code stored in mysql database?

mysql
WWW.MYHIBRID.COM asked:


I know how pull data from the database but I have stored within the a mysql field some text data. Within that that text I have put in some php variables. The problem is that when the browser renders the data that pulled from my sql, the variable stays as $user for example rather than changing to what I needed to. Is there any way to have the server process the php code stored within the mysql database?

Filed under Programming & Design by administrator

Permalink Print 2 Comments

How to automatically regenerate in memory tables after MySQL restarts?

mysql
alex asked:


I want to use in-memory tables for improved performance in MySQL. But what is the cleanest way to ensure that the tables reload (from on-disk tables) when the MySQL server restarts? Is there any way to configure this natively within MySQL, without resorting to Perl and similar external script hacks? Thanks

Filed under Programming & Design by administrator

Permalink Print 1 Comment

How do I motivate myself to learn Mysql at 54?

mysql
George asked:


I am 54. facing huge age discrimination now. Switching from one job to another. I work in the hotel biz as nigh-auditor.
I am trying to concentrate on learning mysql to change my life & maybe getting a better job next year. But i get depressed and discouraged and sometime stop then start learning again. I wonder if I am not too old now ?

Filed under Programming & Design by administrator

Permalink Print 3 Comments

October 2, 2008

How can I save a URL with backslashes in mySql database?

mysql
Joed asked:


I have this problem in storing URL in mySql. I tried to put the URL which came from the file chooser into a String variable. When I printed it, it seemed to be ok but when I saved it in the database, all the backslashes were gone. What should I do? Please help me. Thanks in advance.

Filed under Programming & Design by administrator

Permalink Print 4 Comments