Tag Info

New answers tagged

0

You have a few options: Rebuild MySQL with USE=profiling Upgrade phpMyAdmin Use a more purpose-built tool for the backup: Percona's xtrabackup, mylvmbackup, mysqldump or anything else, in a cronjob.


0

Dan Craven answered the first half of your question, and I agree that it's better to store the path to the file rather than the file itself in your database. MySQL is fully capable of storing the full MP3 file as a BLOB, but can suffer some performance problems along the way. This part is an opinion based question -- there's no universal "right way", but ...


0

In my personal opion (however I am new to databases as well), I would look to store the relative URL, which would be the VARCHAR from here you could store the realtive path to the file (from where the script is being called from) and load the file that way. However it may be worth writing the SQL for your tables as well. Just incase you need to alter or ...


0

Per screenshot is IIS 7.5 not Apache, check IIS if is running. Usually I will suggest to stop IIS and restart apache (check localhost prior connecting to phpmyadmin) ... hope helps..


0

In phpMyAdmin you cannot use DELIMITER in the SQL statement, because you have to define the delimiter on the page instead. Remove both DELIMITER lines from the SQL statements and then, just below the TEXTAREA where you write your SQL, there is an input field that looks like this: [ Delimiter ';'] Change the ';' to your new delimiter, ie. '//'. This also ...


0

You could do this in phpMyAdmin, but you shouldn't. If you insist, you could use an input transformation to do so. You'd have to write one, but doing so shouldn't be too difficult if you have a basic knowledge of PHP. However, this is a bad idea for many reasons, the biggest of which is that you shouldn't be giving your users access through phpMyAdmin. ...


0

File: libraries/dbi/DBIMysqli.class.php 138 public function connect( before return link you can run query: 223 $link->query("SET SESSION wait_timeout = 600"); 224 return $link; This would set any session to mysql db from phpmyadmin with wait_timeout = 600.



Top 50 recent answers are included