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
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/
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.
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
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/