All Questions
Tagged with mysql-5 phpmyadmin
5 questions
0
votes
1
answer
614
views
MySQL UTF-8 Encoding Problem
I have two MySQL databases that are for Wordpress websites. One db is for a live version of a site, the second is a copy of the original that is used in conjunction with a copy of the original site. ...
- 101
0
votes
1
answer
92
views
Mysql query in Database
How to get all the tables from database with all values in tables using single query..
I tried using
$sql = "SHOW TABLES FROM $dbname";
$result = mysql_query($sql);
$arrayCount = 0
while ($row = ...
- 101
1
vote
1
answer
3k
views
Can I use the "import" tool on PHPMyAdmin multiple times?
I am moving databases between a couple of shared hosting accounts, and both of them only give access to the MySQL databases through phpmyadmin.
The importing account's upload limit is 50MB. I would ...
- 115
3
votes
1
answer
2k
views
How can I get MySQL to use the value returned by a function as a default?
I have a pre-existing table that has a column to that can hold a UUID.
I'd like to be able to define a default such that new rows coming in (from legacy systems) will still get a UUID defined, via ...
- 557
2
votes
2
answers
7k
views
Is there any way to recover a database after dropping from phpmyadmin?
I was planning to drop all the tables from a test account, but unfortunately, I didn't notice that I was in the production account when I chose to drop all the tables of my db from phpmyadmin ...
- 391