4 votes
Accepted

How to export query result in a csv file from phpmyadmin

Previously answered correctly here: https://serverfault.com/a/435443 The answer: Execute your sql query in the SQL tab of phpMyAdmin. After execution, scroll down the page and look for “Query ...
g0h's user avatar
  • 156
3 votes
Accepted

How to create user in phpmyadmin to connect two servers?

Create the remote connection To create a remote connection: On your database server, as a user with root privileges, open your MySQL configuration file. To locate it, enter the following command: ...
Michael Yaeger's user avatar
2 votes

Unable to export Magento database using Xampp PhpMyAdmin due to too many input fields that exceed PHP max_input_vars

Add the following lines to php.ini file, max_input_vars = 5000 suhosin.request.max_vars = 5000 suhosin.post.max_vars = 5000
Abdul Majeed's user avatar
2 votes
Accepted

Unable to export Magento database using Xampp PhpMyAdmin due to too many input fields that exceed PHP max_input_vars

Export from command line if you have having issues with exporting from phpMyAdmin. backup/export: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql restore: # mysql -...
Analog's user avatar
  • 2,375
2 votes

How to access cPanel for a website hosted by FastHosts

According to FastHosts, you can access cPanel in three steps: Step 1: Open an Internet browser and enter https://yourserverip:2083 replacing yourserverip with your server's IP address. Step 2: ...
Grant Miller's user avatar
  • 1,183
2 votes

phpMyAdmin no longer notifying me of updates

Most likely this is is caused by missing curl extension and disabled allow_url_fopen. Without these phpMyAdmin can not check for new version and doesn't report this anyhow. This will be fixed in ...
Michal Čihař's user avatar
2 votes

How can I edit the php.ini folder on shared hosting (in /etc/php7/)?

Generally, In Shared Hosting you are not allowed to change php.ini file. But many hosting providers allows to change such parameters of php.ini file through Control Panels like cPanel / Plesk / etc. ...
Nishith Bhimani's user avatar
2 votes
Accepted

How to deploy a single HTML file to static hosting and have it show up for requests to my domain

In most situations renaming your only HTML file index.html is all that you need to do. That is because web servers are nearly universally configured to serve index.html for any requests that resolve ...
Stephen Ostermiller's user avatar
1 vote

How to export query result in a csv file from phpmyadmin

Have you used the export function? Click the format drop down and select csv [UPDATE] OK, I see what you are after. I have just tested this other way of doing it and it works. Same sort of thing, ...
Steve's user avatar
  • 8,438
1 vote

Non-existent tablespace when importing MySQL from phpMyAdmin

Before importing, removing the text /*!50100 TABLESPACE `my_database` */ wherever it appears in the exported MySQL file solves the problem.
authentictech's user avatar
1 vote

Unable to export query result from PHPMyAdmin

The warning explains it all. None of the columns you are trying to join are unique which means there is a possible ambiguity in the statement. i.e. JOIN notice_insolvency_practitioners ni ON ...
Steve's user avatar
  • 8,438
1 vote

Accessing phpmyadmin on ec2 leads to "This site can’t provide a secure connection"

Your attempting to connect to https://www.example.com:80/path/ which obviously won't work because your browser will attempt to connect using SSL but then your server is returning non-SSL information ...
Simon Hayter's user avatar
1 vote

Can I use the Laravel Database Framework without using all of Laravel?

You may use illuminate/database by requiring it in your composer project. composer require illuminate/database Basic usage Create database connection use Illuminate\Database\Capsule\Manager as ...
Yvan's user avatar
  • 111
1 vote

php.ini changes not taking effect in Siteground

So it turns out that my sql file got corrupted when exporting from phpmyadmin. Instead, I exported from command line with this command: mysqldump -u [USER] -p [PASS] db-name > db-name.sql Or if ...
rendell's user avatar
  • 131
1 vote
Accepted

Error configuring phpmyadmin

Sounds like a typical permission problem, you need to ensure that your permissions can correctly read and write the database sock file. Source If your file my.cnf (usually in the /etc/mysql/ ...
Simon Hayter's user avatar
1 vote
Accepted

How to download a dump of the mysql database from the server's /root/

The command that you used does not export the database. It imports whatever was in file.sql into the database. The < points from the file to the database. If you want to export your database ...
Stephen Ostermiller's user avatar
1 vote

phpMyAdmin can't find tmp directory

If you use their shared hosting plan, you should check if the path of phpMyAdmin is on same location of the folder you set with the file. Make sure to check the permissions of that folder and if it'...
Yossi Aharon's user avatar
1 vote

Allow Link access to only one database

PHPMyAdmin is a general MySQL client program. It prompts for a username and password which are used to access the database server directly. i.e. the database credentials and the credentials you enter ...
Quentin's user avatar
  • 1,608
1 vote

Allow Link access to only one database

My Opinion I'm pretty sure you can add phpMyAdmin or search for another admin interface which has access to use specified commands in your databases by creating it in your website ...
knif3r's user avatar
  • 1,067
1 vote

debian phpmyadmin - Call to undefined function __()

What solved this issue for me was to search and purge every php-related package (now also including php-gettext and so on). After reinstalling the packets libapache2-mod-php5 php5 php5-mysql php-...
Bytemaster's user avatar
1 vote

How do I replace a MySQL Database?

There is an alternative way to export and import the database if you have terminal access to the server. Export the file via terminal Execute the following command replacing the MySQL username, ...
Arun Anson's user avatar
1 vote

How do I replace a MySQL Database?

Yes you can. You just export your database as sql file and import it via phpmyadmin. Export: Import: Note that if you have a very large sql file your host might not let you upload it via this ...
dasickle's user avatar
  • 3,658
1 vote

phpMyAdmin unexpected T_OBJECT_OPERATOR error

I suspected this was caused by running a (very) old version of PHP. (It seems PHP 4.2 was installed on the server). The reported "Parse error" is a fundamental syntax error at compile time. Any other ...
MrWhite's user avatar
  • 42.7k

Only top scored, non community-wiki answers of a minimum length are eligible