| Question: |
Good day!Trying to move the site database, the site is unpacked, the database throws an error through phpmyadmin \"Access denied for user `webprom`@`localhost` to database `u891671040_rbs2` \" that mean? Somehow you need to connect the database to the site.. |
| Answer: |
Hello. Open your dam and remove u891671040_rbs2 you have no and cannot be such a base |
| Question: |
And how to transfer the database, usually via phpmyadmin using import downloaded database.. |
| Answer: |
to transfer, just dump the pre-fix, remove the reference to the old database |
| Question: |
how to do it? how to open a dump ? |
| Answer: |
the dump file you can open a normal Notepad. this is a text file |
| Question: |
opened via Notepad, what to fix or delete ? |
| Answer: |
find the line with u891671040_rbs2 what? |
| Question: |
There is the following:-- phpMyAdmin SQL Dump-- version 3.3.4-- http://www.phpmyadmin.net---- Host: db37.valuehost.ru-- generation Time: Sep 29 2014, 16:33-- server Version: 5.0.92-- PHP Version: 5.3.6-- Database: `u891671040_rbs2`--CREATE DATABASE `u891671040_rbs2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;USE `u891671040_rbs2`; |
| Answer: |
delete the entire line with CREATE DATABASE `u891671040_rbs2` |
| Question: |
Now throws the following error:ОшибкаSQL query:---- Database: `u891671040_rbs2`---- ------------------------------------------------------------ Structure of table `ps_1access`--CREATE TABLE IF NOT EXISTS `ps_1access` ( `id_profile` INT( 10 ) UNSIGNED NOT NULL , `id_tab` INT( 10 ) UNSIGNED NOT NULL , `view` INT( 11 ) NOT NULL , `add` INT( 11 ) NOT NULL , `edit` INT( 11 ) NOT NULL , `delete` INT( 11 ) NOT NULL ,PRIMARY KEY ( `id_profile` , `id_tab` )) ENGINE = INNODB DEFAULT CHARSET = utf8;MySQL Response: Documentation#1046 - No database selected |
| Answer: |
you don`t have and can`t be base u891671040_rbs2 remove all lines from the jump cite u891671040_rbs2 |
| Question: |
Deleted all rows where u891671040_rbs2SQL mentioned query:---- Database: `---- ------------------------------------------------------------ Structure of table `ps_1access`--CREATE TABLE IF NOT EXISTS `ps_1access` ( `id_profile` INT( 10 ) UNSIGNED NOT NULL , `id_tab` INT( 10 ) UNSIGNED NOT NULL , `view` INT( 11 ) NOT NULL , `add` INT( 11 ) NOT NULL , `edit` INT( 11 ) NOT NULL , `delete` INT( 11 ) NOT NULL ,PRIMARY KEY ( `id_profile` , `id_tab` )) ENGINE = INNODB DEFAULT CHARSET = utf8;MySQL Response: Documentation#1046 - No database selected |
| Answer: |
in what base you do the import? you have created a database in the panel? |
| Question: |
In base webprom_rbstileМожет need to really dump something to register ? |
| Answer: |
zagruzit the dump to the hosting, we`ll see |
| Question: |
thank you for your help, it sorted out |
| Answer: |
ok
|
| Question: |
Good evening once again!New problem, the base loaded, but the site now reports the following:Link to database cannot be established: SQLSTATE[HY000] [2003] Can`t connect to MySQL server on `db37.valuehost.ru` (4)i.e. as I understand it tries to connect to the old host, how to change it ? |
| Answer: |
the database Server is localhost. Fix it in the configuration file. |
| Question: |
where can I find this file ? |
| Answer: |
What is your CMS? |
| Question: |
prestashop |
| Answer: |
http://novall.net/manual/gde-naxodyatsya-konfiguracionnye-fajly-samyx-populyarnyx-cms.html Configuration file PrestaShopfile is in the folder: /config/settings.inc.php name of the configuration file: settings.inc.php
|
| Question: |
All fixed, now when you log on domain interertorg.ru opens the same site only on a different hosting, for some reason is redirecting to rbstile.ru. Wanted to find the file .htaccess to correct addresses, but never found it in root folder of site files, download it again from backup, but it disappears somewhere. What could be the problem ? |
| Answer: |
Domain registered in the database, I corrected the main entry, check the operation of the site. You need to replace all the remaining entries in the database and replace rbstile.ru on interertorg.ru |
| Question: |
is there a command which allows you to mass change the old domain, as I understand it there is these records, a huge number, because on the website in the card catalog there is a photo/graphic in the descriptions and if the site you want to delete this entire schedule on the new host is also not displayed, since all the addresses are on rbstile.ru |
| Answer: |
On this question you`d better ask on a developer forum, previously make a backup of the database. |
| Question: |
OK, thank you. |
| Answer: |
ok
|
