Question: |
Good afternoon. could you tell me the path to the mysql database***. Need to copy size *** *.. via phpmyadmin does not work |
Answer: |
Hello a Large database it is better to import from a terminal, here is an example of the import command mysql-uLOGINUSER -p password DBNAME < FILEDB.sql |
Question: |
and the path? I will transfer via FTP |
Answer: |
the Base one file is not on the car. You want to export from phpmyadmin and copy via ftp? Here is the export command, it will create one file in place gdy you zapustite team then it is possible to copy it via ftp mysqldump -uLOGINUSER -p password DBNAME > FILEDB.sql |
Question: |
You can help duplicate database *** single user ** user *.... accordingly, database * user * duplicate **... in short we need to swap the subdomain and the main site. |
Answer: |
create a database and tell her name |
Answer: |
I`m going to export two bases, and then will need in the panel to create the new empty database and make the import. Specify the fully loginuser, password, database name for two of the sites |
Question: |
Question through the admin panel see the database size *Disk *** Mbpi the dump *** * can this be? |
Answer: |
the size of dump no relation to the database size has not. the size of the dump is always less than the size of your database, and if the dump is compressed, its size may be smaller than the database |
Question: |
first (*.*.** **** base - ***second - (*.*.*.***** base - * |
Answer: |
need vadymst database*_db skopirovat in stage_bd ? |
Question: |
a better parallel to create a database i.e. user ** create database * and export it from user * (base * which now exists).. and Vice versa for the user * create database *** and export it from user ** (base *** which now exists) |
Question: |
can somehow * or phone unable to explain... |
Answer: |
All clear, let`s in a row, I`m going to export both databases will eventually have two bases, only the content they need swap? |
Answer: |
the Two databases are exported in the root folder /home stage_bd.sql and vadymst*_db.sql \"it is better to create a parallel database\" is a small complication you nesmozhet on behalf of another user in Veste to create the same name database, you can edit only the prefix. please Create two empty database for the desired user, for example calling them so for vadymst* vadymst*_stagedb for the user stage stage_vadymst*bd |
Question: |
OK do export both databases |
Answer: |
Export database ready \\\"in the root folder /home stage_bd.sql and vadymst*_db.sql\\\" please Create a new empty database in the panel,Vesta, write them here with an login and password, and then carry out the import |
Question: |
**user ***base - ***password - ****user *** base - ***password - **** |
Answer: |
Import database produced by the mysql vadymst*_stagedb < stage_bd.sql mysql stage_vadymst*bd < vadymst*_db.sql please Change the configuration files, data connections, and inspect work sites. |
Question: |
almost clear.. http://*.*/***XxfvRwWPr |
Question: |
all. norms. see in phpmyadmin |
Answer: |
the volume bar is not immediately updated, the main thing that the website opened and showed what you need |