| Re: Server crash trouble with all database files Xoops my biggest install, Advice? |
| by dbman on 2011/3/11 18:37:12 Assuming you are referring to database permissions and not file system permissions. If you can get the files to load you can set permissions for the required database user using the mysql grant function. For security reasons you would not want to use the root user as the database user for your xoops install. The syntax for the grant function would be: le="color: #000000"><?php GRANT SELECT, INSERT, UPDATE, DELETE ON xoops_database.* TO username@'databaseserver' IDENTIFIED BY 'password'; edit: you'll need to run: le="color: #000000"><?php flush privileges; after you run the grant statement to clear privilege cache. |
| Re: Server crash trouble with all database files Xoops my biggest install, Advice? |
| by AlexSolo on 2011/3/11 18:14:28 I have the separate files. I thought of combining them once I fix the permission issues. Which should be what? How should the permissions be set so the database functions correctly? As root? with read and write? Read and write for all? When that is fixed I thought of exporting as a SQL for future import to the New server. |
| Re: Server crash trouble with all database files Xoops my biggest install, Advice? |
| by dbman on 2011/3/11 17:43:47 If you have single database file in SQL format you can easily run that directly in your new server or on your local Mac server. Connect to the new database and load or copy paste the file in the SQL editor. If the file was generated as a full SQL backup this will build the tables and insert the records. If you don't have a SQL file but do have the data files (*.myi, *.myd,etc) use the method mention in the link to restore. |
| Re: Server crash trouble with all database files Xoops my biggest install, Advice? |
| by AlexSolo on 2011/3/11 16:43:11 I do have a current version of phpmyadmin, locally on my mamp install. Seem easy to change permissions and then export as a single database file for future import into new server. Relatively painless. thanks for pointing me in the right direction. My version of phpmyadmin was so old, on the original server, that feature was not part of the install. |
| Re: Server crash trouble with all database files Xoops my biggest install, Advice? |
| by AlexSolo on 2011/3/11 16:07:14 I do have the actual data files. I will read this and see if I can understand it. Please check back as I may need additional advice. |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|