phpmyadmin

wamp cannot load mysqli extension

WAMP installed fine, no problems, BUT... When going to phpMyAdmin, I get the error from phpMyAdmin as follows: "Cannot load mysqli extension. Please check your PHP configuration". Also, phpMyAdmin documentation explains this error message as follows: "To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL exte...

How do I get phpMyAdmin to connect to a local mysql server?

Hi everyone, I have my config.inc.php file, and have set my host name to localhost. Unfortunately, I have no idea what my username/password should be. Is that something I need to configure on the MySql side? I tried creating an arbitrary username/password (admin/password), but when I try to log into phpMyAdmin with those credentials,...

How to convert an Access database to SQL?

Hi. I want to convert my Access database to SQL because my host only supports importing a database through SQL in their phpmyadmin. ...

import csv or sql thru phpmyadmin and skip PK?

Is it possible to have phpmyadmin or other tool to import a csv or sql backup into an existing DB and skip the primary key or is this a manual, table by table process of inserting with queries and manually removing the primary key? ...

MySQL query in PHP gives obvious wrong result.

Hi there, I'm using PHP and PHPMyAdmin to create a small profile site. I'm giving members an ID number, based on which is the biggest number currently in the database, +1 I did 25 tests before I got the PHP script where I wanted it to be. I then deleted those 25 entries using PHPMyAdmin. But now, when my PHP code does this: function...

How to change bdb cache size in mysql?

I would like to change variable bdb cache size (bdb_cache_size) on my mysql database to be able to import bigger SQL files (yes, i've set all other variables for example in php.ini to higher values and it does not work) in phpmyadmin. How can I do that? ...

What problems can arise if php mysql client doesn't match the mysql server version?

I have two installations of mysql server 5.1.32 and 5.0.77 (same machine, os x leopard). My php mysql extension is compiled against 5.0.77 (that was the easiest thing to do, and I did it after installing 5.1.32). I'm using the 5.1.32 installation since that's what I compiled my python MySQLdb extension against. I don't code in php much i...

how do I add a foreign key pointing to the same table using myphpadmin?

I have an existing InnoDB table which already has foreign keys pointing to different tables. But when I try to create a foreign key pointing to the Primary index, I get an error (check data type). The table is User with User_Id as the Primary. I want a foreign key Manager_ID which is a FK to User_Id. Both of INT Both of Length 10 Uns...

phpmyadmin security

I have a production server with apache2, php, mysql. I have just one site right now (mysite.com) as a virtual host. I want to put phpmyadmin, webalizer, and maybe webmin on there. So far, I installed phpmyadmin, and it works but the whole internet can go to mysite.com/phpmyadmin How can I reduce the visibility to say 192.168.0.0/16 so...

How to access phpMyAdmin on remote server

For my websites I use Dreamhost. Dreamhost requires you to create a hostname (ex: mysql.mclindigital.com) that the database will reside on. For me it's simple, if I want to access phpMyAdmin, I simply navigate to mysql.mclindigital.com, and it enters into phpMyAdmin automatically. Apparently Dreamhost is in the minority using this met...

How to offset dates in a MySQL database by 1 second?

I've imported a bunch of posts into a Wordpress site that all have the exact same date. I'd like to edit the post dates so they are offset by one second. My concern is that there may be a performance issue when all of the dates are the same. Anyone know quick way to get this done using phpMyAdmin to edit the MySQL database or some other ...

Free or open source .Net database view/edit tools like phpMyAdmin

Hi, all I'm trying to find a (web) tool which view/edit and execute customized sql cmd on a shared hosting just like what phpMyAdmin do. or to say, an dotNet version phpMyAdmin. I'm using it to manage and edit a sql server express database. There's one name myLittleAdmin, but it's not free... ...

How i can import a file(csv/excel) with partial data to table in database through phpmyadmin?

I needed from my client updated information to fill a clients table. I exported the table that i wanted to an excel file, and asked them to fill with the new information (it was only a column that i needed updated) and they've sent me back the file. Now I want to import that information back to my table column. Trial and error many tim...

MySQL Timestamp - why all zeros?

I'm using PHPMyAdmin and I've got a MySQL table column called "timestamp." The type (surprise!) is TIMESTAMP, and in 'attributes' I've set it to ON UPDATE CURRENT_TIMESTAMP. However, each new record gets a timestamp that looks like this: 0000-00-00 00:00:00 I have explicitly set the default value to none, but when I save and come bac...

Getting this error while creating a recordSet in Dreamweaver - Using MAMP

I get this error after installing mamp and setting up my site on dreamweaver. I connected to a database I created in phpMyAdmin, then i tried to create a recordSet for my application then i get this error. While executing addDynamicSource in Recordset.htm, a JavaScript error occured. Any idea anybody what this is and how to fix it. tha...

getting 'pma_history' marked as crashed in phpmyadmin

hi, i am having problem with mysql , i am getting Table.'\phpmyadmin\pma_history' is marked as crashed and should be repaired . which is creating problem for my site to access the database can anybody help me to rid this error . ...

mySQL field with a dashed line under it.?

can anyone please explane what does that dashed line stands for i am using phpmyadmin field are name type NULL default longtitude float No 0.001 latitude float No 0.001 thank you. ...

MySQL import in phpmyadmin (CSV) chokes on quotes

I am trying to import a .csv file into a MySQL table via phpMyAdmin. The .csv file is separated by pipes, formated like this: data|d'ata|d'a"ta|dat"a| data|"da"ta|data|da't'a| dat'a|data|da"ta"|da'ta| The data contains quotes. I have no control over the format in which I recieve the data -- it is generated by a third party. The pro...

How do I run MySQL commands?

I'm in the process of updating my Symphony installation and I've been told to "run these MySQL commands" to complete the process. Funny thing... I have no idea how to do that. The commands I'm mean to run are as follows: ALTER TABLE `sym_sections` ADD `navigation_group` VARCHAR( 50 ) NOT NULL DEFAULT 'Content'; ALTER TABLE `sym_sect...

phpmyadmin "no data received to import" error, how to fix?

I use xampp on a pc atwork to host a database. I exported a backup ("bintra.sql") using phpmybackuppro. I use xampp on a mac at home, and when I try to import the sql file located on my desktop, I get this error. No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size perm...