| Question: |
Good day! Tell me how the VESTA toolbar to create a new database using the existing dump site? |
| Question: |
In General, we kind of figured out, but when you try to import the dump via PHPmyAdmin error SQL query:CREATE DATABASE IF NOT EXISTS `fon` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;Answer MySQL:#1044 - Access denied for user `admin_sitdev`@`localhost` to database `fon` |
| Answer: |
Hello create the database menu DB go to http://138.201.133.57/phpmyadmin/ and then download the dump |
| Question: |
All created, not loaded...dump the CREATE DATABASE IF NOT EXISTS `fon` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;Answer MySQL:#1044 - Access denied for user `admin_sitdev`@`localhost` to database `fon` |
| Answer: |
this means that you have not selected the database in phpmyadmin |
| Answer: |
and base fon You can not be remove from database dump of the string database is created, fon |
| Question: |
So chose, entered it and clicked import... |
| Answer: |
base fon You can not be
remove from database dump of the string database is created, fon |
| Question: |
A database named \"fon\" I understand can not create it will add the prefix everywhere admin_fon...I honestly do not rummage in MySQL So that a row of the database is created, fon the dump vryat be able to remove... |
| Answer: |
open the dump in Notepad and delete the lines you create and select byzy fon |
| Question: |
OK! ATP |
| Answer: |
ok
|
| Question: |
And another prompt if you specify the connection parameters to the database type prefix admin_*** need to specify? And then try to connect to the database and does not work....Now has the following form:// ** MySQL settings - You can get this info from your web host ** ///** The name of The database for WordPress */define(`admin_wp`);/** MySQL database username */define(`admin_sitdev`);/** MySQL database password */define(`devpas`);/** MySQL hostname */define(`localhost`);/** Database Charset to use in creating database tables. */define(`utf8mb4`);/** The Database Collate type. Don`t change this if in doubt. */define(`DB_COLLATE`, \"); |
| Answer: |
prefixes ukazyvayutsya in the site settings. prefixes do you have in the database, in tables. it is not the name of the database |
| Question: |
In short changed, here`s a look. It seems like the connection occurs but displays a simple white screen. This is due to what can it be? Need configure htaccess to register separately for this folder.Link to index http://neftetrader.com/freakornot/index.php // ** MySQL settings - You can get this info from your web host ** ///** The name of The database for WordPress */define(`wp`, );/** MySQL database username */define(`sitdev`, `root`);/** MySQL database password */define(`devpas`, `yourPass`);/** MySQL hostname */define(`localhost`, `localhost`);/** Database Charset to use in creating database tables. */define(`utf8mb4`, `utf8mb4`);/** The Database Collate type. Don`t change this if in doubt. */define(`DB_COLLATE`, \"); |
| Answer: |
define(`sitdev`, `root`); is incorrect , this user you have no |
| Question: |
I replaced the define(`sitdev`,); \"sitdev\" - I have the same user has |
| Answer: |
no you created a database user at the same time as created, SAMC base. specify the user. |
| Question: |
The newly created database, now I cannot log into PHpmyAdmin it gives an error could not connect to MySQL server - have you got something? or am I not doing something? |
| Answer: |
we can`t be, because the server is not ours but yours. proverit is true whether You have entered the access settings, username and password |
| Question: |
Everything went.... |
| Answer: |
ok
|
| Question: |
In short, all re-done, still a white screen...define(`admin_wps`,);/** MySQL database username */define(`admin_developper`, );/** MySQL database password */define(`devpas`, );/** MySQL hostname */define(`localhost`, );/** Database Charset to use in creating database tables. */define(`utf8mb4`, );/** The Database Collate type. Don`t change this if in doubt. */define(`DB_COLLATE`, \") |
| Answer: |
which site database you added? you have all sites the user sitdev not admin |
| Question: |
If I would not have the correct settings it would give an error connection to the database... And then just a white screen, Maybe it`s something with htaccess we have with other sites the exact same problem were you somehow htaccess shaman and then it worked... |
| Answer: |
first opredeliat kind of website which user. connected, to the same user, add the abzu. |
| Question: |
This is a separate page on a domain lying neftetrader.com. In short, I realized that I had to go to VESTU not under the administrator and under the user sitdev and from there a base to create? |
| Answer: |
always with the sites need to work as sitdev or another user. under the admin only need to change the settings |
| Question: |
In General I am under the user \"sitdev\" create new database \"wps\" and database user \"wp\"define(`sitdev_wps`,);/** MySQL database username */define(`sitdev_wp`, );/** MySQL database password */define(`devpas`, );/** MySQL hostname */define(`localhost`, );/** Database Charset to use in creating database tables. */define(`utf8mb4`, );/** The Database Collate type. Don`t change this if in doubt. */define(`DB_COLLATE`, \"); |
| Answer: |
the config is filled with syntax errors PHP Parse error: syntax error, unexpected `)` in /home/sitdev/web/neftetrader.com/public_html/freakornot/wp-config.php on line 23 |
| Answer: |
what is define(`sitdev_wps`,); ? what is define(`sitdev`, ); ? define(`devpas`, ); define(`localhost`, ); define(`utf8mb4`, ); what is it? you shift website or ustanavlivaet it again? |
| Question: |
Error in the name of the database is obtained. I ask you a very could you it to fill in the above settings that we all suffer ;)))) |
| Answer: |
you transfer the website or ustanavlivaet it again? |
| Question: |
The developer gave us a site on Wordpress, we need it to test install in a folder on a domain freakornot neftetrader.com so he could open at http://neftetrader.com/freakornot/index.php |
| Answer: |
install or migrate?these are two huge differences the site is on wordpess will not open from the http://neftetrader.com/freakornot if there was ustanovlen on neftetrader.com you transfer the website or ustanavlivaet it again? you messed up the configuration file if move - download nisporeny if ustanavlivat that configuration file generally should not be |
| Question: |
Set, the original configuration file, I`ll update |
| Answer: |
if ustanavlivaet UTB no there is no configuration file and must be Yong the database must be completely empty. Ustinovka produced exclusively in the browser |
| Question: |
moved the original file |
| Question: |
Well, I don`t know if they have it already stood some test domain... They gave us a ready-made archive website and all... |
| Answer: |
If I have the right fields, You already eat a work site, and You have the files for the website and database? I understand You correctly? |
| Question: |
Is there a website neftetrader.com it works, it`s all right, he do not have their database( this is a simple landing page), on it we create a separate folder \"freakorenot\" ( in which logim how would another website and it do database called wps). It should open at neftetrader.com/freakorenot/index.php |
| Answer: |
OK, what CMS are You installing? |
| Question: |
Wordpress |
| Answer: |
the address indicated is not correct http://neftetrader.com/freakornot we sozdali You database and set up the connection. database name: < / span>sitdev_freakor database user: sitdev_freakor password: how on Your account |
| Question: |
OK |
| Answer: |
OK |
| Question: |
http://neftetrader.com/freakornot/ error page not found |
| Answer: |
http://neftetrader.com/freakornot/ Update the page, apparently from the cache You have displayed. |
| Question: |
Still a long time trying to load and then a grey page without graphics like css is not loaded... |
| Answer: |
You uploaded the database that was previously installed on the local computer? |
| Question: |
Most likely Yes |
| Question: |
Us developer sent the finished website and how and where it developed on the local machine or it is difficult for us to say... |
| Answer: |
smotrite what the problem is, the site was developed on a local computer, strasnogo in General is nothing, but the developer has sent all the settings for the local computer, ask the developer to change the settings and set the path in the database, respectively http://neftetrader.com/freakornot/ has sent You the database, You need only redownload the database and website have to earn |
