Support

Site Restoration

#23444 problem restoring- 1046 error

Posted in ‘Site restoration’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
n/a
CMS Type
Other
CMS Version
n/a
Backup Tool Version
n/a
Kickstart version
n/a

Latest post by on Thursday, 12 November 2015 17:20 CST

user88366
couldnt run kickstart on new host (after developing on xammp)
so opted to move files via ftp and restore via sql -change config file

any help appreciated...............

Error

SQL query:

--
-- Database: `dwc2`
--
-- --------------------------------------------------------
--
-- Table structure for table `s75j0_akeeba_common`
--
CREATE TABLE IF NOT EXISTS `s75j0_akeeba_common` (
`key` varchar( 255 ) NOT NULL ,
`value` longtext NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8;

MySQL said: Documentation
#1046 - No database selected  

tampe125
Akeeba Staff
Hello Rob,

how are you trying to import the SQL file?
The best way is to connect to PhpMyAdmin, select the database you want to restore and then load the script in the Import page.

Anyway, why you couldn't use Kickstart? Which error did you get?

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user88366
yes davide i was using that method.............thanks

since subscribing i have tried to use the site export feature in pro( which i now installed (was using free version before)
and it seems the folder the host company requires you to publish in is a subdirectory?

previously was running installer - then the error was that i didnt have access to the webpage
all files were extracted as i could see them in filezilla?

regards

rob

tampe125
Akeeba Staff
The Site Transfer feature sometimes could not due to local or remote server configuration. In such cases the best thing to do is to take a full site backup, transfer it locally and upload it again on the remote server.

What do you mean you didn't have any access to the webpage?
Can you please post a screenshot of the error?
Moreover, can you please follow Kickstart troubleshooter guide and apply its suggestions?

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user88366
ok will have another go with new pro created archive and kickstart pro

cheers

user88366
Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.
Apache/2.2.3 (CentOS) Server at www.dwccarpentry.com Port 80

took a snap of the ftp screen also-attached

regards

tampe125
Akeeba Staff
mhm... I suspect what's going on: data sent between page refresh is too big and your server throws an error.
You have to extract it locally, then upload it all to the new server. Finally when you visit the new site the ANGIE installation page will show up.

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user88366

i am a donut!

clue was in sql error message!
was importing -but hadnt selected the pre-setup db the host provided when running the query

thanks for the help

couldnt get angie to work at all even extarcting locally!!

tampe125
Akeeba Staff
ok, let me know if you need more help on this.

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!