phpmyadmin
Import SQL file by command line in Windows 7
Try like this: I think you need to use the full path at the command line, something like this, perhaps: C:\xampp\mysql\bin\mysql -u {username} -p {databasename} < file_name.sql Refer this link also: http://www.ryantetek.com/2011/09/importing-large-sql-files-through-command-line-when-using-phpmyadminxampp/
What are the “Internal Relations” defined in phpMyAdmin?
This is a phpmyadmin internal mechanism to manage relationship between tables. This feature is actually useful for MYISAM tables which don’t support foreign keys and constraints. By defining internal relations in phpmyadmin you link tables together which otherwise can’t be linked. These information are stored in a phpmyadmin specific table inside your MySQL server (phpmyadmin.PMA_relation). … Read more
How to find out mySQL server ip address from phpmyadmin
The SQL query SHOW VARIABLES WHERE Variable_name=”hostname” will show you the hostname of the MySQL server which you can easily resolve to its IP address. SHOW VARIABLES WHERE Variable_name=”port” Will give you the port number. You can find details about this in MySQL’s manual: 12.4.5.41. SHOW VARIABLES Syntax and 5.1.4. Server System Variables
How to unhide a hidden table in PHPMyAdmin 4+?
Once a table is hidden, a light bulb or eye (depending on version) should appear next to the database name. Click on that, and it will bring up a dialog box with the hidden tables, allowing you to unhide (show) them.
change default collation in phpmyadmin
In your Mysql configuration change the default-character-set operative under the [mysqld] tab. For example: [mysqld] default-character-set=utf8 Don’t forget to restart your Mysql server afterwards for the changes to take effect.
Fatal error: Uncaught Error: Function name must be a string in C:\xampp\htdocs\em0126\app\code\core\Mage\Core\Model\Layout.php:555 Stack trace: #0
Your solution Fatal error: Uncaught Error: Function name must be a string in … app\code\core\Mage\Core\Model\Layout.php:555 … This error was easy to fix because the problem was in the following line: $out .= $this->getBlock($callback[0])->$callback[1](); Instead it should be: $out .= $this->getBlock($callback[0])->{$callback[1]}(); find your detail solution here on below given link http://www.code007.ro/making-work-magento-with-php-7-rc1/