I am dealing with tables with 50+ million rows with much more columns. But they do not contain more than 1 text column. Are columns of type text or varchar?

The performance also depends on the...

I never faced any problem with much larger tables (in GBs).

Are you properly indexing your tables? For performance, you can split the tables on year/month basis if you have datatime field....

There is a simple rule, always treat user input an evil :)

You are welcome.

Can you clarify the "certain data"? Read all about JOINs at MySQL Manual (http://dev.mysql.com/doc/refman/5.0/en/join.html).

No, you can not.


You are right, you have to use views.

I am not sure about this. You have to test it yourself by implementing both approaches.

Don't forget to index email and username in tables before uisng JOIN.

Use \ before any special character. If you using PHP, then use mysql_real_escape_string() (http://php.net/mysql_real_escape_string) function.

MySQL does not have any native GUI as MS Access have. You can choose from a lot of 3rd party MySQL GUIs (http://www.mwasif.com/2008/6/mysql-gui-tools). There is another open source option available...

Yes, it will increase the performance dramatically.
Check this article for more info http://articles.sitepoint.com/article/optimizing-mysql-application

Do you have index on username and date columns?

This is the way to do. If you need only name from the db, then simply use name in the SELECT statement instead of *.

$row=mysql_select("SELECT name FROM table where id='1'") or die(mysql_error());

If ip field is varchar then use quotes around $ip in the query. But if you want to insert in INT format then use INET_ATON()...

Do not use quotes around column names.

$sql = mysql_query("INSERT INTO tc_mailist (fname, lname, email, ip) VALUES ('Joe', 'Bloggs', 'joe@bloggs.com', $ip)");

The above queries are for MySQL. Did you try it?

You are welcome

From PHP Manual (http://www.php.net/manual/en/mysqli.overview.php).

The mysqli extension, or as it is sometimes known, the MySQL improved extension, was developed to take advantage of new features...

The correct query will be

SELECT * FROM quotes WHERE job_status = 'active' AND date_posted<= DATE_SUB(NOW(), INTERVAL 7 DAY)

You don't need to install XAMPP if you want to run MySQL there. Simply download (http://dev.mysql.com/downloads/mysql/5.1.html) MySQL separately from MySQL.com and install it.

Your question is not clear. Do you want to use MySQL running on other machine?

This post (http://forums.mysql.com/read.php?61,17950,18900) on MySQL Forum might help you.

I believe MySQL does not support dblink.

Look at MySQL manual to Enable Incremental Backups (http://dev.mysql.com/doc/refman/5.1/en/backup.html).

GRANT privileges to MySQL user to connect remotely.

You can easily save images in MySQL (http://www.mwasif.com/2007/4/save-image-in-mysql-with-php/) (follow the link) using PHP.

Please find here the table limit (http://dev.mysql.com/doc/refman/5.0/en/full-table.html). You can increase the limit by ALTERing Max_data_length.

Max_data_length is in bytes as Upsilon said.

What is the collation of $lookby? Did you alter table structure or upgraded MySQL?

You need to use LIMIT (http://dev.mysql.com/doc/refman/5.1/en/select.html)

$sql = 'SELECT * FROM Possesions ORDER BY quantity DESC LIMIT 0,10';

Copy .FRM, .MYD and .MYI files from the database directory. But you can do this only with MyISAM tables.

Post the warnings here.

Import .sql to MySQL and then export it via any GUI tool (http://www.mwasif.com/2008/6/mysql-gui-tools/) or export as CSV with a simple PHP script...

You can use phpMyAdmin to upload your DB, look for it into your control panel.

To connect to database, you will need to provide hostname (most probably in your case will be localhost), mysql user...

Never tell to such clients to use MySQL GUI, most of the time they destroy things :-)

Use the following library http://www.bettina-attack.de/jonny/view.php/projects/php_writeexcel/

Are you using link identifier with mysql_query()?

Use the following query to update the record
UPDATE t1, (SELECT * FROM t1 where id=214) as t2 SET
t1.last_name = t2.last_name,
t1.date_column = t2.date_column,
t1.marital_status =...

You should use MySQL FULLTEXT (http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html) searching capability.

Look here for examples...

This should work for you

SELECT mag.mag_id, mag.name, mag_cat.category_name, COUNT(*) AS subscribers
FROM Magazine mag
LEFT JOIN Magazine_Category mag_cat ON mag.cat_id = mag_cat.cat_id
LEFT...

Hi Naveen,

MySQL FULLTEXT search works well with small data but as data grows the performance starts decreasing. Did you try MySQL query cache? This will work for you a bit if your table does not...

There is no option in the CPanel to view the password.