: How do I solve this error when importing MySQL databases into phpMyAdmin? As part of a system rebuild of my local machine, I have exported all of my MySQL databases using the Export tab in

As part of a system rebuild of my local machine, I have exported all of my MySQL databases using the Export tab in phpMyAdmin. The result is one large file containing each database and their respective tables.

My setup is a MacBook running MAMP 3 Pro

Upon trying to restore the databases, I am running into a problem where phpMyAdmin seems to want the each of the databases to be created first. A typical error message is:

Error
SQL query:

-- Database: myfirstdatabase

1046 - No database selected

I have clearly gone about backing up my databases in the wrong way, but is there a method for easily recovering from this situation?

10.01% popularity Vote Up Vote Down

: Can Joomla have a different URL for backend management? My site will be maintained mostly by myself, and maybe 1 or 2 others. I want to know if it's possible if the back end can be managed

@Cooney921

Posted in: #Joomla #Security #Url

2 Comments

: Is there any way to get keywords about a website Is there any tool or service where I can put a website url and it will give me the keywords this site is known for or associated with.

@Cooney921

Posted in: #Keywords

2 Comments

: The Knowledge Graph is a knowledge base used by Google to enhance its search engine's search results with semantic-search information gathered from a wide variety of sources.

@Cooney921

0 Comments

: Informing Googlebot for deprecated pages I publish timetables in my website. For example last year I published Number 2 bus Summer 2013 timetable. I has pretty good ranking on Google SERPs for

@Cooney921

Posted in: #Googlebot #Serps

2 Comments

Login to post a comment!

1 Comments

Sorted by latest first Latest Oldest Best

@Vandalay111

When exporting, phpmyadmin has an option (under the "custom" configuration) to "CREATE DATABASE / USE statement". If you didn't check that, then your export file won't create the databases.

As far as recovering, you'll need to create each database manually. Not the tables and schemas though, just create the database itself and your existing default export format should create the tables for you.

10% popularity Vote Up Vote Down

Feed

: How do I solve this error when importing MySQL databases into phpMyAdmin? As part of a system rebuild of my local machine, I have exported all of my MySQL databases using the Export tab in

More posts by @Cooney921

: Can Joomla have a different URL for backend management? My site will be maintained mostly by myself, and maybe 1 or 2 others. I want to know if it's possible if the back end can be managed

: Is there any way to get keywords about a website Is there any tool or service where I can put a website url and it will give me the keywords this site is known for or associated with.

: The Knowledge Graph is a knowledge base used by Google to enhance its search engine's search results with semantic-search information gathered from a wide variety of sources.

: Informing Googlebot for deprecated pages I publish timetables in my website. For example last year I published Number 2 bus Summer 2013 timetable. I has pretty good ranking on Google SERPs for

Login to post a comment!

1 Comments

Back to top | Use Dark Theme